Re: How to begin a transaction PART II

What comes through to me ... loudly and clearly ... is that you are trying to do in Oracle what you would do in a Microsoft product: STOP IT!

In 12+ years of Oracle I've never once found a need to concern myself with the things you are asking about.

If you want to be something other than an anachronism in Oracle ... you need to learn Oracle. And that doesn't mean learn how to imitate a Microsoft product. The Oracle database is NOT just SQL Server with a different name. It is a very different product. And you will likely bring it to its knees and then blame Oracle for what is clearly what you are doing.

Daniel Morgan

"Carlos Hernández" wrote:

> 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 - 14:25:00 CST