SYS.LOAD_UNDO_STAT dependencies on DBMS_SQL

Line 11: cid := dbms_sql.open_cursor;

7: BEGIN
8: val := ubks * 100000 + qlen + 100;
9: loadsql := 'alter system set "_undo_debug_usage" = ' || val;
10: dbms_output.put_line(loadsql);
11: cid := dbms_sql.open_cursor;
12: dbms_sql.parse(cid, loadsql, dbms_sql.native);
13: rows := dbms_sql.execute(cid);
14: dbms_sql.close_cursor(cid);
15: END load_undo_stat;

Line 12: dbms_sql.parse(cid, loadsql, dbms_sql.native);

8: val := ubks * 100000 + qlen + 100;
9: loadsql := 'alter system set "_undo_debug_usage" = ' || val;
10: dbms_output.put_line(loadsql);
11: cid := dbms_sql.open_cursor;
12: dbms_sql.parse(cid, loadsql, dbms_sql.native);
13: rows := dbms_sql.execute(cid);
14: dbms_sql.close_cursor(cid);
15: END load_undo_stat;

Line 13: rows := dbms_sql.execute(cid);

9: loadsql := 'alter system set "_undo_debug_usage" = ' || val;
10: dbms_output.put_line(loadsql);
11: cid := dbms_sql.open_cursor;
12: dbms_sql.parse(cid, loadsql, dbms_sql.native);
13: rows := dbms_sql.execute(cid);
14: dbms_sql.close_cursor(cid);
15: END load_undo_stat;

Line 14: dbms_sql.close_cursor(cid);

10: dbms_output.put_line(loadsql);
11: cid := dbms_sql.open_cursor;
12: dbms_sql.parse(cid, loadsql, dbms_sql.native);
13: rows := dbms_sql.execute(cid);
14: dbms_sql.close_cursor(cid);
15: END load_undo_stat;