Oracle DBMS_RESULT_CACHE_INTERNAL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Undocumented
AUTHID DEFINER
Dependencies
DBA_OBJECTS DBMS_NETWORK_ACL_ADMIN DBMS_RC_LIB
Documented No
First Available 11.1.0.6
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtrc.plb
Subprograms
RELIES_ON    
 
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. */

Related Topics
Built-in Functions
Built-in Packages
DBMS_CLIENT_RESULT_CACHE
DBMS_RESULT_CACHE
DBMS_RESULT_CACH_API
Result Cache (SQL)
Result Cache (PL/SQL)
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved