DBA Data[Home] [Help]

SYS.RMJVM dependencies on IDL_CHAR$

Line 328: dbms_output.put_line('delete from idl_char$');

324: exit when total_to_delete <= deletions_per_iteration;
325: total_to_delete := total_to_delete - deletions_per_iteration;
326: end loop;
327:
328: dbms_output.put_line('delete from idl_char$');
329:
330: select count(*) into total_to_delete
331: from idl_char$ where obj# in (select obj# from java$rmjvm$aux);
332: commit;

Line 331: from idl_char$ where obj# in (select obj# from java$rmjvm$aux);

327:
328: dbms_output.put_line('delete from idl_char$');
329:
330: select count(*) into total_to_delete
331: from idl_char$ where obj# in (select obj# from java$rmjvm$aux);
332: commit;
333: loop
334: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
335: initjvmaux.rollbackset;

Line 336: delete from idl_char$ where obj# in (select obj# from java$rmjvm$aux)

332: commit;
333: loop
334: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
335: initjvmaux.rollbackset;
336: delete from idl_char$ where obj# in (select obj# from java$rmjvm$aux)
337: and rownum <= deletions_per_iteration;
338: commit;
339: exit when total_to_delete <= deletions_per_iteration;
340: total_to_delete := total_to_delete - deletions_per_iteration;