DBA Data[Home] [Help]

SYS.RMJVM dependencies on DBMS_SQL

Line 101: DDL_CURSOR := dbms_sql.open_cursor;

97: loss_count number := 0;
98: BEGIN
99: previous_iterations := 10000000;
100:
101: DDL_CURSOR := dbms_sql.open_cursor;
102:
103: loop
104:
105: exec('delete from java$rmjvm$aux2');

Line 143: dbms_sql.parse(DDL_CURSOR, cmd, dbms_sql.native);

139: BEGIN
140: -- Issue the Alter Statement (Parse implicitly executes DDLs)
141: cmd := 'DROP PUBLIC SYNONYM '||
142: sys.dbms_assert.enquote_name(syn_name, false);
143: dbms_sql.parse(DDL_CURSOR, cmd, dbms_sql.native);
144:
145: EXCEPTION
146: WHEN OTHERS THEN
147: my_err := SQLCODE;

Line 160: dbms_sql.close_cursor(DDL_CURSOR);

156: END LOOP;
157: CLOSE C1;
158:
159: end loop;
160: dbms_sql.close_cursor(DDL_CURSOR);
161:
162: END;
163: commit;
164:

Line 534: DDL_CURSOR := dbms_sql.open_cursor;

530: ddl_statement varchar2(200);
531: my_err number;
532: BEGIN
533:
534: DDL_CURSOR := dbms_sql.open_cursor;
535:
536: loop
537: done := true;
538: OPEN C1(already_done);

Line 559: dbms_sql.parse(DDL_CURSOR, sys.dbms_assert.noop(ddl_statement),

555: END;
556:
557: BEGIN
558: -- Issue the Alter Statement (Parse implicitly executes DDLs)
559: dbms_sql.parse(DDL_CURSOR, sys.dbms_assert.noop(ddl_statement),
560: dbms_sql.native);
561: EXCEPTION
562: WHEN OTHERS THEN
563: null; -- ignore, and proceed.

Line 560: dbms_sql.native);

556:
557: BEGIN
558: -- Issue the Alter Statement (Parse implicitly executes DDLs)
559: dbms_sql.parse(DDL_CURSOR, sys.dbms_assert.noop(ddl_statement),
560: dbms_sql.native);
561: EXCEPTION
562: WHEN OTHERS THEN
563: null; -- ignore, and proceed.
564: END;

Line 571: dbms_sql.close_cursor(DDL_CURSOR);

567: CLOSE C1;
568: exit when done;
569:
570: end loop;
571: dbms_sql.close_cursor(DDL_CURSOR);
572:
573: END;
574: commit;
575: