Re: Control for "Isolation level" at SELECT statement level

From: Yong Huang <yong321_at_yahoo.com>
Date: 19 Aug 2003 07:45:43 -0700
Message-ID: <b3cb12d6.0308190645.7999320e@posting.google.com>

"Dave Hau" <davehau-no-spam-123_at_no-spam.netscape.net> wrote in message news:<glU%a.1829$wk.1381_at_newssvr25.news.prodigy.com>...
> If what you're asking is whether you can have a select statement within a
> transaction, that has an isolation level different than the isolation level
> of the transaction, no you cannot do that in Oracle.
>
> Cheers,
> Dave

Dave,

A little addition. How about have an autonomous transaction inside the "parent" transaction? Then you should be able to use a different isolation level from that in the "parent".

Yong Huang Received on Tue Aug 19 2003 - 09:45:43 CDT