|Subject:||Implied commit in dbms_sql...?|
|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 := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cursor_name, string, DBMS_SQL.NATIVE);
ret := DBMS_SQL.EXECUTE(cursor_name);
then I try to execute a delete statement on a test table:
exec('delete from t');
When I try to select data from table t from another session I still can
If I "commit;" from window where I previously executed the proc...rows
Shouldn't instead be implied this commit?
Is there something that escape to me...
Thx to all.