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" ?