Oracle DBMS_RESULT_CACHE

Oracle DBMS_RESULT_CACHE_API Version 11.2.0.3

General Information

Purpose

Result Cache administration. This package consists of only a header with functionality defined using PRAGMA INTERFACE (C....

AUTHID

DEFINER

Dependencies

No Dependencies except Standard

First Available

11.1.0.6

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 N UMBER 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