| General Information |
| Purpose |
Result Cache administration |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsrcad.sql |
| First Available |
11.1.0.6 |
| Dependent Objects |
No Dependencies |
| Security Model |
Execute is granted to PUBLIC |
| Subprograms |
|
| |
| 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 |
