Implied commit happens with DDL only. Up to you to commit DML.
devjnr_at_gmail.com wrote:
> I'm using pl/sql developer and trying to test implied commit that
> dbms_sql should do.
>
> I copied a proc from ora docs like this:
>
> CREATE OR REPLACE PROCEDURE exec(STRING IN varchar2) AS
> cursor_name INTEGER;
> ret INTEGER;
> BEGIN
> cursor_name := DBMS_SQL.OPEN_CURSOR;
>
> DBMS_SQL.PARSE(cursor_name, string, DBMS_SQL.NATIVE);
> ret := DBMS_SQL.EXECUTE(cursor_name);
> DBMS_SQL.CLOSE_CURSOR(cursor_name);
> END;
>
>
> then I try to execute a delete statement on a test table:
>
> begin
> exec('delete from t');
> end;
>
> When I try to select data from table t from another session I still can
> see data...
>
> If I "commit;" from window where I previously executed the proc...rows
> go.
>
> Shouldn't instead be implied this commit?
>
> Is there something that escape to me...
>
> Thx to all.
Received on Tue Aug 29 2006 - 10:59:23 CDT
