Re: How to control transaction using ADODB and Xorasession

Actually, what he asked for is not really clear.

1. You read that he wants to put everything in a particular rb. (which may be what he is asking for)
2. He wants to know how to do a commit or a rollback.

I, perhaps wrongly, assumed that he thought he had to assign things to a rb just to do a transaction (which he does not). I some other databases one has to explicitly start a transaction and so I thought that may be where he was or is coming from.

One might also interpret what he is saying that he has 2 different sessions and he wants to make them part of the same transaction - not possible.

The information you gave certainly is correct. It is unclear what he is asking for exactly.
Jim

"David Fitzjarrell" <oratune_at_msn.com> wrote in message news:32d39fb1.0203291523.425ba03e_at_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 - 21:07:30 CST