In a procedure I declare a large varchar2 as 32000 ("SQL_Total").

The procedure also declares a ref cursor ("rc_das1 ").

In "SQL_String" I "compose" a sizable SQL statement .

Then I do my "open rc_das1 for Sql_Total;".

I run a "test" on the procedure and if "SQL_Total" is 100% correct all is well.

With some SQL problems Oracle is of no real assistance in "finding the problem area". "SQL_Total" exists but I can
only get see "(long value)" when I attempt to view it.

Is there some way that I can view, export, or save "SQL_Total" ?
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.
Marco -
I understand and thank you for the reply.

Dave
© Allround Automations forums