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