Urgent: Pl/sql Blocked

[Gil]

Hello,
I am using from a long time pl/sql. The version installed is the latest available: 5.1.4.

I don't know why this morning I cannot connect to my production database 8.1.7.4: at the beginnig the pl/sql blocked after I typed the password wihout complete the logon phase. Now it blocked when I try a sql command.

I am trying to understand what it is doing when it blocked and what I see is the following istruction:
"begin :id := sys.dbms_transaction.local_transaction_id; end;"

At the moment I am completely blocked and I cannot use pl/sql on my production db. The problem doens't exist on other database of the same version.

Gilberto.

 

[Marco Kalter]

I can't imagine what might cause this. If the problem is related to the specific state of a specific database instance, then perhaps you can try to shutdown and restart the database instance?