DBA Data[Home] [Help]

SYS.INITJVMAUX dependencies on DBMS_ASSERT

Line 80: sys.dbms_assert.simple_sql_name(rollback_segment_name);

76: debug_output('skipped rollback segment ' || rollback_segment_name);
77: exception when no_data_found then
78: deallocate_rollback_name := rollback_segment_name;
79: sec_rollback_segment_name :=
80: sys.dbms_assert.simple_sql_name(rollback_segment_name);
81: begin
82: exec('create rollback segment ' || sec_rollback_segment_name ||
83: ' storage (initial 2 m next 2 m maxextents unlimited)');
84: exec('alter rollback segment ' ||

Line 101: sys.dbms_assert.simple_sql_name(rollback_segment_name);

97: end loop;
98: end;
99:
100: sec_rollback_segment_name :=
101: sys.dbms_assert.simple_sql_name(rollback_segment_name);
102: END;
103:
104: procedure rollbackset as
105: begin

Line 120: sec_name := sys.dbms_assert.simple_sql_name(deallocate_rollback_name);

116: loop
117: declare
118: sec_name varchar2(32); -- 30+2
119: begin
120: sec_name := sys.dbms_assert.simple_sql_name(deallocate_rollback_name);
121: drp('alter rollback segment ' || sec_name || ' offline');
122: begin
123: drp('drop rollback segment ' || sec_name);
124: exit;

Line 335: drp('drop java class ' || sys.dbms_assert.enquote_name(name, false));

331: end;
332:
333: procedure drop_sys_class(name varchar2) as
334: begin
335: drp('drop java class ' || sys.dbms_assert.enquote_name(name, false));
336: drp('drop public synonym ' || sys.dbms_assert.enquote_name(name, false));
337: end;
338:
339: procedure drop_sys_resource(name varchar2) as

Line 336: drp('drop public synonym ' || sys.dbms_assert.enquote_name(name, false));

332:
333: procedure drop_sys_class(name varchar2) as
334: begin
335: drp('drop java class ' || sys.dbms_assert.enquote_name(name, false));
336: drp('drop public synonym ' || sys.dbms_assert.enquote_name(name, false));
337: end;
338:
339: procedure drop_sys_resource(name varchar2) as
340: begin

Line 341: drp('drop java resource ' || sys.dbms_assert.enquote_name(name, false));

337: end;
338:
339: procedure drop_sys_resource(name varchar2) as
340: begin
341: drp('drop java resource ' || sys.dbms_assert.enquote_name(name, false));
342: end;
343:
344: function compare_releases(first varchar2, second varchar2) return varchar2 as
345: posx number:=0;

Line 619: sys.dbms_assert.enquote_name(uname,FALSE) || '.' ||

615: begin
616: fetch C1 into uname,oname;
617: -- zsqi LRG 4937433 (Enquote_Name in place of manually added quotes)
618: ddl_statement := 'DROP JAVA DATA ' ||
619: sys.dbms_assert.enquote_name(uname,FALSE) || '.' ||
620: sys.dbms_assert.enquote_name(oname,FALSE);
621: exit when C1%NOTFOUND or loop_count > iterations;
622: exception when others then
623: my_err := sqlcode;

Line 620: sys.dbms_assert.enquote_name(oname,FALSE);

616: fetch C1 into uname,oname;
617: -- zsqi LRG 4937433 (Enquote_Name in place of manually added quotes)
618: ddl_statement := 'DROP JAVA DATA ' ||
619: sys.dbms_assert.enquote_name(uname,FALSE) || '.' ||
620: sys.dbms_assert.enquote_name(oname,FALSE);
621: exit when C1%NOTFOUND or loop_count > iterations;
622: exception when others then
623: my_err := sqlcode;
624: if my_err = -1555 then -- snapshot too old, re-execute fetch query