Viewing bind variable values in 10g - Any suggestions?
From: Teijo Lallukka <teijo.lallukka_at_edita.fi>
Date: Thu, 06 Nov 2008 11:58:34 +0200
Message-Id: <s912dc02.083@gw00.edita.fi>
Date: Thu, 06 Nov 2008 11:58:34 +0200
Message-Id: <s912dc02.083@gw00.edita.fi>
Hi list members!
Do you know way to view bind variables which are used in insert/update statement?
I know that in 10g there is a view v$sql_bind_capture but it is very limited and only usefull when bind is in where or having clause. And also there is bug in timestamp datatype which will be fixed 11.2, I think.
I would be thankfull for all ideas how to get binds from db without touching application to get trace or debug info...
-Teijo L.
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 06 2008 - 03:58:34 CST