Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SESSION , 18 of 19
This procedure returns a list of active namespaces and contexts for the current session.
TYPE AppCtxRecTyp IS RECORD ( namespace VARCHAR2(30), attribute VARCHAR2(30), value VARCHAR2(256)); TYPE AppCtxTabTyp IS TABLE OF AppCtxRecTyp INDEX BY BINARY_INTEGER; DBMS_SESSION.LIST_CONTEXT ( list OUT AppCtxTabTyp, size OUT NUMBER);
Parameter | Description |
---|---|
list |
Buffer to store a list of application context set in the current session. |
Return | Description |
---|---|
list |
A list of (namespace, attribute, values) set in current session |
size |
Returns the number of entries in the buffer returned |
The context information in the list appears as a series of <namespace
> <attribute
> <value
>. Because list
is a table type variable, its size is dynamically adjusted to the size of returned list.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|