Topic Options
#23444 - 07/29/06 12:43 AM View Large VarChar2 Created Within A Procedure?
Dave Sharpe Offline
Member

Registered: 11/12/03
Posts: 50
Loc: Roanoke,VA USA
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" ?

Top
#23445 - 07/31/06 05:43 PM Re: View Large VarChar2 Created Within A Procedure?
Marco Kalter Administrator Offline
Member

Registered: 08/30/99
Posts: 17147
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 Kalter
Allround Automations

Top
#23446 - 07/31/06 06:30 PM Re: View Large VarChar2 Created Within A Procedure?
Dave Sharpe Offline
Member

Registered: 11/12/03
Posts: 50
Loc: Roanoke,VA USA
Marco -
I understand and thank you for the reply.

Dave

Top


Moderator:  support