hangs on ORA-02055

[Maxmix]

Hi,

Very often, I receive the following (expected) exception, when running some code, making distributed DML calls.



In this example, it was INSTEAD OF trigger, that did some updates on remote databases.

For unknown reason, the error is fatal. I am clicking on the "No" button, and the application enters in "not responding" state, for ever.

Annoying!

 

[Marco Kalter]

Can you reproduce the "Not responding" issue? If so, then to obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[Maxmix]

I've sent the file to support@allroundautomations.com,
subject: requested debug.txt

(The only debug.txt I could find was in c:\oracle\PLSQLDev - that is, in application directory)

 

[Marco Kalter]

Thanks. I see many "ORA-02067: transaction or savepoint rollback required" errors in the log file. We'll try to handle this exception.

 

[Maxmix]

Fine! Please, let me know when good version is available.