Watch variable length limit in debug is too short

[El Ladron]

Hi,

I have a lot of dynamic SQL in my stored procedures which involve quite long strings being built up. My problem however is that I'm finding it frustrating that PL/SQL Developer seems to have a hard-coded limit when it comes to showing variable values in the debug watch window (and hover-over function) which means I can't step through my code and validate before executing SQL that may then fail.

Is there a way of changing this limit?

I'm using PL/SQL Developer Version 7.1.5.1396 on Windows XP.

"El Ladron"

 

[Marco Kalter]

Unfortunately this is not hard-coded in PL/SQL Developer, but in Oracle's SYS.DBMS_DEBUG API.

 

[rbrooker]

you could use an autonomous transaction and store it in a table with a timestamp, procedure reference...