Re: pl/sql - auto commit

No, as you can see in the example below you can rollback what is doing a procedure. So, it does not commit.

SQL>create table t (col number);

Table created.

SQL>create procedure f as
  2 begin
  3 insert into t values(1);
  4 end;
  5 /

Procedure created.

SQL>exec f;

PL/SQL procedure successfully completed.

SQL>select * from t;

       COL

         1

1 row selected.

SQL>rollback;

Rollback complete.

SQL>select * from t;

no rows selected

Nandakumar a écrit dans le message <7pvbs9$p22$1_at_nnrp1.deja.com>...
>Do pl/sql sub programs 'COMMIT' for any INSERT/UPDATE operations handled
>inside, on successful exit?
>
>--
>Nandakumar
>(N.Kumar_at_rocketmail.com)
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Aug 25 1999 - 03:09:56 CDT