ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Undocumented Result Cache support functionality.
AUTHID
DEFINER
Dependencies
DBMS_NETWORK_ACL_ADMIN
DBMS_RC_LIB
Documented
No
First Available
11.1
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvtrc.plb
RELIES_ON
Undocumented
dbms_result_cache_internal.relies_on(table_name IN VARCHAR2);
SQL> sho user
USER is "SYS"
SQL> sho con_name
CON_NAME
------------------------------
PDBDEV
SQL> desc dbms_result_cache_internal
PROCEDURE RELIES_ON
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABLE_NAME VARCHAR2 IN
SQL> exec dbms_result_cache_internal('UWCLASS.SERVERS');
BEGIN dbms_result_cache_internal('UWCLASS.SERVERS'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object DBMS_RESULT_CACHE_INTERNAL
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
/* no combination tried, CDB$ROOT, PDB, specify owner, user SYS table produces a different output. */