Re: How to begin a transaction PART II

I guess I need to continue the top-posting pattern here.

As someone who switched to Informix after working for a long time with Oracle (I am now back with Oracle, but that's another story), I remember how frustrating it was in the beginning. It's difficult for people to modify their work patterns, attitude, way of thinking. I know that in the beginning, I kept on saying,'why can't #$%^ Informix let me do the things the same way I did in Oracle!?'

Eventually, you realize that,"when in Rome, do as the Romans do." If Informix does it this way, then I just need to learn to do it the Informix way. Unfortunately, for some people, this adjustment is nearly impossible, and they will try with all their might to bend the product before they bend themselves. They'll bang their head against the brick wall for a long time until they realize that they won't succeed in knocking down the wall just by banging their head against it. At that point, they'll do one of three things:

1. They'll get a sledge hammer
2. Walk away in disgust
3. Learn to work with the wall instead of against it

So I think we need to convince Mr Hernandez that the third option is his best course of action.

Cheers,
Avi.

damorgan wrote:

> 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 Sun Feb 10 2002 - 07:05:00 CST