Debug modified code

[he]

Hallo,

with PL/SQL Developer it is possible to debug modified code.

Szenario:
PL/SQL Developer runs in "multi session mode".

1) Open a "Test Window"
2) Call a PL/SQL routine in the database.
3) Debug the code and finish the debug (abort or run)
The Code is now open in a new tab of the "Test Window"
4) Open the sourcecode in a new window (edit mode)
5) Change the code (add / drop lines) and recompile
6) Go back to the "Test Window" and debug again.

The souce tab now shows the old code anymore.
Debug works correctly. But curious to see the debugger stops in a empty line or in a comment.

Tested in version 8.x, 9.0.4. and 9.0.5.

Please check it out.

Thanks, he

 

[Marco Kalter]

I cannot immediately reproduce this. As soon as the program is recompiled in a Program Window, the corresponding source Test Window is refreshed.

I assume you are using the Program Window to change the program?

 

[he]

Hello Marco,

thank you for your question. I think I've got it out now.

You're right, the Code Tab will refresh when the code has manipulated in the same instance of PL/SQL Developer in which is debugged. But when you use multiple instances (with different users on the same db at the same time) than the code will not be refreshed.

The details:

There is one user e.g. "my_owner" who owns a procedure / function / package. my_owner is connected in one instance of the PL/SQL Developer. In a "Program Window" the source code is open (edit mode).

There is another user e.g. "my_user" connected in a second instance. This users runs and debugs the code in a "Test Window".

After my_user has once debuged the code in the second instance, my_owner compiles a changed code in the first instance. Then my_user will debug again, but the code in the Souce Tab of the "Test Window" is unchanged.

In special cases it is nessesary for us to debug code with a user-account (after enhancement of priviledges) instead of the owner-account.

I've not tested the behaviour with the new "multi connection mode" of PL/SQL Developer 9.x and neither with to PL/SQL Developers on two different computers.

Hope it's clear now and you can help.
Thanking you in anticipation.

he

 

[Marco Kalter]

Okay, we'll try to enhance this.