ORA-01453 SET TRANSACTION must be first statement of transaction

[cvandemaele]

From within a command window, I can do

> ALTER SESSION SET ISOLATION_LEVEL = SERIALIZABLE

without any problems. But, when the current isolation level is SERIALIZABLE, i cannot change it back to READ COMMITTED. I systematically get the above mentioned error message. In SQL*Plus, the problem does not occur.

 

[Marco Kalter]

Apparently the Command Window executes something else after executing a command. As a result, you can only use a SET TRANSACTION statement immediately after opening a new Command Window.

I will look into this, maybe this can be prevented.

------------------
Marco Kalter
Allround Automations