6: rows integer;
7: BEGIN
8: val := 2;
9: resetsql := 'alter system set "_undo_debug_usage" = ' || val;
10: cid := dbms_sql.open_cursor;
11: dbms_sql.parse(cid, resetsql, dbms_sql.native);
12: rows := dbms_sql.execute(cid);
13: dbms_sql.close_cursor(cid);
14: END reset_undo_stat;
7: BEGIN
8: val := 2;
9: resetsql := 'alter system set "_undo_debug_usage" = ' || val;
10: cid := dbms_sql.open_cursor;
11: dbms_sql.parse(cid, resetsql, dbms_sql.native);
12: rows := dbms_sql.execute(cid);
13: dbms_sql.close_cursor(cid);
14: END reset_undo_stat;
8: val := 2;
9: resetsql := 'alter system set "_undo_debug_usage" = ' || val;
10: cid := dbms_sql.open_cursor;
11: dbms_sql.parse(cid, resetsql, dbms_sql.native);
12: rows := dbms_sql.execute(cid);
13: dbms_sql.close_cursor(cid);
14: END reset_undo_stat;
9: resetsql := 'alter system set "_undo_debug_usage" = ' || val;
10: cid := dbms_sql.open_cursor;
11: dbms_sql.parse(cid, resetsql, dbms_sql.native);
12: rows := dbms_sql.execute(cid);
13: dbms_sql.close_cursor(cid);
14: END reset_undo_stat;