Oracle | DBMS_RESULT_CACHE

Oracle DBMS_RESULT_CACHE_API Version 23c

General Information

Library Note

Morgan's Library Page Header

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 Finds a given object in the cache or (optionally) creates one if one is not found.

AUTHID DEFINER

Dependencies

STANDARD (only)

Documented No

First Available 11.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsrcad.sql

Subprograms

GET	SET	SETC
GETC

GET

Finds a given object in the cache or (optionally) creates one if one is not found dbms_result_cache_api.get( key IN VARCHAR2, value OUT NOCOPY RAW, isPublic IN NUMBER DEFAULT 0, noCreate IN NUMBER DEFAULT 0, noFetch IN NUMBER DEFAULT 0) RETURN NUMBER; pragma interface(C, Get);

TBD

GETC

Finds a given object in the cache or (optionally) creates one if one is not found dbms_result_cache_api.getc( key IN VARCHAR2, value OUT NOCOPY VARCHAR2, isPublic IN NUMBER DEFAULT 0, noCreate IN NUMBER DEFAULT 0, noFetch IN NUMBER DEFAULT 0) RETURN NUMBER; pragma interface(C, GetC);

TBD

SET

Stores the value with the key specified with the last call to Find (which had created an empty new object) dbms_result_cache_api.set( value IN RAW, discard IN NUMBER DEFAULT 0) RETURN NUMBER; pragma interface(C, Set);

TBD

SETC

Stores the value with the key specified with the last call to Find (which had created an empty new object) dbms_result_cache_api.setc( value IN VARCHAR2, discard IN NUMBER DEFAULT 0) RETURN NUMBER; pragma interface(C, SetC);

TBD