Re: Commit

From: Arlette BROSSARD <abray_at_club-internet.fr>
Date: 28 Mar 1999 22:19:59 GMT
Message-ID: <01be7969$0cc4bea0$b8a524c3@ntdv2113>

You need to declare a transaction for that.

You can use :

DBMS_TRANSACTION.READ_WRITE; at the begining
DBMS_TRANSACTION.COMMIT; or DBMS_TRANSACTION.ROLLBACK; at the end

abray_at_club-internet.fr

Denis <dc_mariano_at_hotmail.com> a écrit dans l'article <01be784e$09b82d80$905067cf_at_95-mariandc>...
> If I have a stored procedure A that inserts record in table A and calls
> stored procedure B that inserts record in table B, does Oracle consider
> this a logical record? Meaning, if I rollback in stored procedure A,
will
> the insert in table B be also rolled back? My Commit in A also commits
my
> B?
>
> Thank you in advance.
>
> Denis
>
Received on Sun Mar 28 1999 - 16:19:59 CST