Viewing contents of varchars > 4000 when debugging

MikeyC

Member
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
 
Unfortunately the Oracle Debug API is limited to about 1000 characters. Beyond that, you will see a "Long value" message displayed.
 
Back
Top