Implied commit in dbms_sql...?

Giganews Newsgroups
Subject: Implied commit in dbms_sql...?
Posted by:  devjā€¦@gmail.com
Date: 29 Aug 2006

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.

Replies