Re: OCI - HowTo set rollback segment for transaction??
Date: Wed, 8 Mar 2000 10:55:23 +0100
Message-ID: <8a5827$jch$1_at_news1.tele.dk>
Hmm,
The manuals from Oracle states that you can't execute
SET TRANSACTION USE ROLLBACK SEGMENT SOME_ROLLBACK_SEGMENT;
using OCI
So,,??
René
DriftWood <drift_wood_at_my-deja.com> wrote in message
news:8a3kl6$3sd$1_at_nnrp1.deja.com...
> You can simply execute this SQL as the first statement in your
> transaction... I looked to see if there was an attribute for this on
> the transaction handle or a way to set it when initializing the
> transaction and there doesn't appear to be any way other than just
> using the SQL.
>
> So you do OCITransStart(...) followed by an OCIStmtPrepare(...),
> OCIStmtExecute(...) of the SQL just as you posted.
>
>
> --
> -cheers
> DW
> --------------------------------------------------------------------
> "It is a kind of good deed to say well; and yet words are not deeds.
> -William Shakespeare"
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 08 2000 - 10:55:23 CET