How to join v$sql_bind_metadata

Hi Experts,

I want to join the view v$sql_bind_metadata to get the sentences (sql_text) that owns the bind variables but when a try to do that with v$open_cursor no rows are returned.

The database version is 9.2.0.8 so there is no v$sql_bind_capture.

V$SQL_BIND_METADATA

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)