Re: How to control transaction using ADODB and Xorasession

From: David Fitzjarrell <oratune_at_msn.com>
Date: 29 Mar 2002 15:23:28 -0800
Message-ID: <32d39fb1.0203291523.425ba03e@posting.google.com>

That's not the response he was looking for, nor deserved.

set transaction use rollback segment <segmentname>;

will cause all DML to use the specified rollback segment until either a rollback or commit is issued. This will ensure that any DML generated by either stored procedure will 'hit' only the specified rollback segment.

David Fitzjarrell

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<Hh0p8.165251$q2.15912_at_sccrnsc01>...
> Rollback segment has nothing to do with it.
> execute sp1
> execute sp2
> rollback; or commit;
> voila.
> Jim
> "yewpc" <member_at_dbforums.com> wrote in message
> news:3ca44454$1_at_usenetgateway.com...
> > I am trying to run 2 Stored Procedure in a sequence.The first One using
> > ADODB.connection and the other one using Xorasession. How can I bind
> > these 2 SP under one rollback segment. Can you give an example on how to
> > commit and rollback.
> >
> >
> >
> > --
> > Posted via dBforums
> > http://dbforums.com
Received on Fri Mar 29 2002 - 17:23:28 CST