Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
V$SQL_BIND_METADATA
describes, for each distinct bind variable in each cursor owned by the session querying this view:
Bind metadata provided by the client, if the bind variable is user defined
Metadata based on the underlying literal, if the CURSOR_SHARING
parameter is set to FORCE
and the bind variable is system-generated.
Column | Datatype | Description |
---|---|---|
ADDRESS |
RAW(4 | 8) |
Memory address of the child cursor that owns this bind variable |
POSITION |
NUMBER |
Bind position |
DATATYPE |
NUMBER |
Bind datatype |
MAX_LENGTH |
NUMBER |
Maximum length of the bind value |
ARRAY_LEN |
NUMBER |
Maximum number of array elements (for array binds only) |
BIND_NAME |
VARCHAR2(30) |
User-defined or system-generated bind variable name (if used) |