| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Commit
A copy of this was sent to "Arlette BROSSARD" <abray_at_club-internet.fr>
(if that email address didn't require changing)
On 28 Mar 1999 22:19:59 GMT, you wrote:
>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
>
in other databases you need to 'begin work' but not in Oracle. A transaction is implicitly started with the first statement and is not ended until you simply "commit" or "rollback".
No need for the dbms_transaction package to do this. It just happens.
>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
>>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |