Implied commit in dbms_sql...?

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:34:41 CDT