Re: Autocommit after 1000 transactions?

From: Bobby S. Mukundan <bobby_at_sdt.com>
Date: 1995/09/18
Message-ID: <43koet$oq9_at_aadt.sdt.com>#1/1


>
>I don't know if the following is true for Oracle v.7 - it applies to v.6:
>You may issue as many commit statements as you want inside a pl/sql programme.
>But the transaction(s) is/are only committed at exit from the programme.
>

I am of the opinion that in PL/SQL Ver 2 and above, a transaction is committed as soon as the commit statement is executed, inside a PL/SQL block/procedure.

Could someone enlighten me, if I'm wrong?

-Bobby Received on Mon Sep 18 1995 - 00:00:00 CEST

Original text of this message