Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to begin a transaction PART II
Ok. I undertand the concepts.
But, if I would like change the isolation level of a transaction (via SQL Plus) and initiate the transaction on the next line on mode Read Write?
This code on PL/SQL via SQL PLUS not runs:
set transaction isolation level serializable;
set transaction read write; ( <- ORA-01453 )
Update ....... (Begin the transaction)
Commit;
How to change the isolation level and mode read/write on the same transaction?
Thanks.
Carlos Hernández
Barcelona (Spain)
Received on Thu Feb 07 2002 - 09:39:33 CST