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