When Im change isolation level in plsql developer SECOND TIME then got ORA-01453: SET TRANSACTION must be first statement of transaction
Alter session statement do not begin and end any transaction himself isnt?
ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE
ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE
ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE
COMMIT
ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE
is the same
New contributor
Ishul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.