Oracle DBMS_CLIENT_RESULT

Oracle DBMS_CLIENT_RESULT_CACHE Version 11.2.0.3

General Information

AUTHID

CURRENT_USER

Data Types

TYPE crc_rcln IS RECORD (
regid             NUMBER,
username          VARCHAR2,
location_name     VARCHAR2,
subscription_name VARCHAR2);

TYPE crc_trcln IS TABLE of crc_rcln;

Dependencies

DBMS_ASSERT	GV$SESSION_CLIENT_RESULT_CACHE	PLITBLM
DBMS_LOCK	INVALIDATION_REGISTRY$	REG$
DBMS_SYSTEM

First Available

11.2

Security Model

Owned by SYS with no privileges granted

Source

{ORACLE_HOME}/rdbms/admin/prvthcrc.plb

CACHE_CLEANUP

Undocumented

dbms_client_result_cache.cache_cleanup(flags IN NUMBER) RETURN dbms_client_result_cache.crc_trcln;

SELECT dbms_client_result_cache.cache_cleanup(1)
FROM dual;

Related Topics

DBMS_RESULT_CACHE

DBMS_RESULT_CACHE_API

Result Cache (SQL)

Result Cache (PL/SQL)

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated: