I'm trying to understand what it is that you are trying to do and why?
a serializable transaction *is* read write (well until you hit a row that
changed since you began your transaction anyway when it bombs out).
Perhaps a brief explanation of the problem you are trying to solve would
help?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Carlos Hernández" <paisal67NO_at_SPAMhotmail.com> wrote in message
news:a3u719$6md$1_at_talia.mad.ttd.net...
> 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 - 10:12:32 CST
