Print Thread
Viewing contents of varchars > 4000 when debugging
#13779 03/25/04 03:55 PM
Joined: Mar 2004
Posts: 2
Hertfordshire, England
M
MikeyC Offline OP
Member
OP Offline
Member
M
Joined: Mar 2004
Posts: 2
Hertfordshire, England
When debugging PLSQL code which was building dynamic ref cursors, I found it was not possible to view the contents of VARCHARS longer than 2000 characters. Is this a limitation that will be lifted in future versions? In this scenario, being able to see the whole query string and check
it is being built correctly would be extremely useful.

BTW Thanks for a great product - it really improves productivity!

Mike Campbell

Re: Viewing contents of varchars > 4000 when debugging
#13780 03/25/04 09:52 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
Unfortunately the Oracle Debug API is limited to about 1000 characters. Beyond that, you will see a "Long value" message displayed.


Marco Kalter
Allround Automations

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.038s Queries: 14 (0.007s) Memory: 2.4967 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-03-28 16:39:14 UTC
Valid HTML 5 and Valid CSS