DBA Data[Home] [Help]

SYS.DBMS_JVM_EXP_PERMS dependencies on DBMS_JVM_EXP_PERMS

Line 1: package body DBMS_JVM_EXP_PERMS as

1: package body DBMS_JVM_EXP_PERMS as
2: EXP_END CONSTANT PLS_INTEGER := 999999;
3: EXP_START CONSTANT PLS_INTEGER := 0;
4: cursor policy_q is select kind, grantee, type_schema,type_name,
5: name,action, enabled from dba_java_policy where

Line 241: TJP SYS.DBMS_JVM_EXP_PERMS.TEMP_JAVA_POLICY;

237: if state = EXP_END-1 then
238: new_block :=1;
239: return
240: 'DECLARE
241: TJP SYS.DBMS_JVM_EXP_PERMS.TEMP_JAVA_POLICY;
242: CURSOR C1 IS SELECT KIND,GRANTEE,TYPE_SCHEMA,TYPE_NAME,
243: NAME,ACTION,ENABLED FROM TEMP_JAVA_PRIVS;
244: BEGIN
245: OPEN C1;

Line 248: SYS.DBMS_JVM_EXP_PERMS.IMPORT_JVM_PERMS(TJP);

244: BEGIN
245: OPEN C1;
246: FETCH C1 BULK COLLECT INTO TJP;
247: CLOSE C1;
248: SYS.DBMS_JVM_EXP_PERMS.IMPORT_JVM_PERMS(TJP);
249: EXECUTE IMMEDIATE(''DROP TABLE TEMP_JAVA_PRIVS'');
250: END;';
251: end if;
252: -- export is done

Line 256: end DBMS_JVM_EXP_PERMS;

252: -- export is done
253: return '';
254: end export_perms;
255:
256: end DBMS_JVM_EXP_PERMS;