Topic Options
#13779 - 03/25/04 10:55 AM Viewing contents of varchars > 4000 when debugging
MikeyC Offline

Registered: 03/25/04
Posts: 2
Loc: 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

#13780 - 03/25/04 04:52 PM Re: Viewing contents of varchars > 4000 when debugging
Marco Kalter Administrator Offline

Registered: 08/30/99
Posts: 17174
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


Moderator:  support