check values for binding variables

From: <tienlee_at_mailexcite.com>
Date: Mon, 14 Dec 1998 22:31:01 GMT
Message-ID: <7543j5$orn$1@nnrp1.dejanews.com>

I am running Oracle 8 and want to check the values for the binding variables on cursors. When I check v$sql table, I can only see (example) select name, address from customer_tbl where ssn = :a1 and tel = :a2. I want to know what's in :a1 and :a2.

I checked all v$ related tables (v$sql, v$sqltext, v$sql_bind_data ...etc) and can't seem to find the values assigned to those binding variables. Any expert DBAs out there can help me on this ?

Thanks in advance.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 14 1998 - 16:31:01 CST