The Oracle Debugger can only show values of up to 1000 bytes. You would have to write the value to a debug table, ot use dbms_output, or some other method to see the result.