DBA Data[Home] [Help]

SYS.DBMS_JAVA_DEV dependencies on DBMS_REGISTRY

Line 15: if dbms_registry.is_in_registry('JAVAVM') then

11: grantee varchar2(130);
12: stmt varchar2(2000);
13: begin
14:
15: if dbms_registry.is_in_registry('JAVAVM') then
16: select distinct owner, referenced_name bulk collect
17: into jdev_grantees, jdev_grants
18: from sys.dba_dependencies
19: where referenced_owner in ('SYS','PUBLIC') and owner != 'PUBLIC'

Line 70: if dbms_registry.is_in_registry('JAVAVM') then

66: procedure enable is
67: stmt varchar2(2000);
68: begin
69:
70: if dbms_registry.is_in_registry('JAVAVM') then
71: execute immediate 'alter trigger sys.dbms_java_dev_trg disable';
72:
73: execute immediate 'alter session set "_ORACLE_SCRIPT" = TRUE';
74: