PL SQL Developer 7 Version 7.0.0.1050 (MBCS)

[mortalzera]

Hi,

I have been trying to debug a trigger in plsql developer, but I can't see the values of any :new and ld column when debugging any trigger.

We can't update for now because my company don't have money to buy new licenses.

Is there anything I could do to solve this problem?

Thanks.

 

[Marco Kalter]

This is indeed a debugger restriction. It still exists in the current PL/SQL Developer version.

 

[mike]

Not fancy, but this should work:
1. Create a table with a column to hold text.
2. Create a procedure to insert text into the table and commit. Use "PRAGMA AUTONOMOUS_TRANSACTION;" so any commits to the table do not commit in the trigger.
3. Temporarily change your trigger to call the procedure once for each of the values or to list any messages saying where the trigger is at.

 

[mortalzera]

Mike, we are using temporary variables to hold the ld and :new values. We should also try your method, depending on circunstancies.

Marco Kalter, is this a tool limitation? Or it is plsql built that way?