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 236: TJP DBMS_JVM_EXP_PERMS.TEMP_JAVA_POLICY;

232: if state = EXP_END-1 then
233: new_block :=1;
234: return
235: 'DECLARE
236: TJP DBMS_JVM_EXP_PERMS.TEMP_JAVA_POLICY;
237: CURSOR C1 IS SELECT KIND,GRANTEE,TYPE_SCHEMA,TYPE_NAME,
238: NAME,ACTION,ENABLED FROM TEMP_JAVA_PRIVS;
239: BEGIN
240: OPEN C1;

Line 243: DBMS_JVM_EXP_PERMS.IMPORT_JVM_PERMS(TJP);

239: BEGIN
240: OPEN C1;
241: FETCH C1 BULK COLLECT INTO TJP;
242: CLOSE C1;
243: DBMS_JVM_EXP_PERMS.IMPORT_JVM_PERMS(TJP);
244: EXECUTE IMMEDIATE(''DROP TABLE TEMP_JAVA_PRIVS'');
245: END;';
246: end if;
247: -- export is done

Line 251: end DBMS_JVM_EXP_PERMS;

247: -- export is done
248: return '';
249: end export_perms;
250:
251: end DBMS_JVM_EXP_PERMS;