[Home] [Help]
79: -- Given the value of a bind_data column captured in v$sql and a
80: -- bind position, this function returns the value of the bind
81: -- variable at that position in the SQL statement. Bind position
82: -- start at 1. This function returns value and type information for
83: -- the bind (see object type SQL_BIND).
84: --
85: -- PARAMETERS:
86: -- bind_data (IN) - value of bind_data column from v$sql
87: -- position (IN) - bind position in the statement (starts from 1)
94: -- - bind position is invalid or out-of-bound
95: -- - the specified bind_data is NULL.
96: --
97: -- NOTE:
98: -- name of the bind in SQL_BIND object is not populated by this function
99: ----------------------------------------------------------------------------
100: FUNCTION extract_bind(
101: bind_data IN RAW,
102: bind_pos IN PLS_INTEGER)
99: ----------------------------------------------------------------------------
100: FUNCTION extract_bind(
101: bind_data IN RAW,
102: bind_pos IN PLS_INTEGER)
103: RETURN SQL_BIND;
104:
105: --------------------------------- extract_binds -----------------------------
106: -- NAME:
107: -- extract_binds
115: -- bind_data (IN) - value of bind_data column from v$sql
116: --
117: -- RETURN:
118: -- This function returns collection (list) of bind values of
119: -- type sql_bind.
120: --
121: -- NOTE:
122: -- For the content of a bind value, refert to function extract_bind
123: -----------------------------------------------------------------------------
122: -- For the content of a bind value, refert to function extract_bind
123: -----------------------------------------------------------------------------
124: FUNCTION extract_binds(
125: bind_data IN RAW)
126: RETURN SQL_BIND_SET PIPELINED;
127:
128: -------------------------------- is_bind_masked -----------------------------
129: -- NAME:
130: -- is_bind_masked