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

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

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

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

Top


Moderator:  support