Oracle DBMS_RESULT_CACHE_INTERNAL
Version 18.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented Result Cache suppor functionality.
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 18c
What's New In 19c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx