Print Thread
View Large VarChar2 Created Within A Procedure?
#23444 07/29/06 04:43 AM
Joined: Nov 2003
Posts: 50
Roanoke,VA USA
D
Member
OP Offline
Member
D
Joined: Nov 2003
Posts: 50
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" ?

Re: View Large VarChar2 Created Within A Procedure?
#23445 07/31/06 09:43 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
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
Re: View Large VarChar2 Created Within A Procedure?
#23446 07/31/06 10:30 PM
Joined: Nov 2003
Posts: 50
Roanoke,VA USA
D
Member
OP Offline
Member
D
Joined: Nov 2003
Posts: 50
Roanoke,VA USA
Marco -
I understand and thank you for the reply.

Dave


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.037s Queries: 14 (0.010s) Memory: 2.5022 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-03-28 17:21:02 UTC
Valid HTML 5 and Valid CSS