DBA Data[Home] [Help]

SYS.DBMS_JAVA_DEV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

    select distinct owner, referenced_name bulk collect
    into jdev_grantees, jdev_grants
    from sys.dba_dependencies
    where referenced_owner in ('SYS','PUBLIC') and owner != 'PUBLIC'
      and owner != referenced_owner
      and referenced_name in ('DBMS_JAVA','DBMS_JAVA_TEST','SQLJUTL',
                              'SQLJUTL2','JVMRJBCINV','DBMS_JAVA_MISC');
Line: 94

    (select NAME, obj# from OBJ$ where status= 4)
   LOOP
    BEGIN
     sys.dbms_utility.validate ( rec.obj# );