| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
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) |