Viewing bind variable values in 10g - Any suggestions?

From: Teijo Lallukka <>
Date: Thu, 06 Nov 2008 11:58:34 +0200
Message-Id: <>

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

-- Received on Thu Nov 06 2008 - 03:58:34 CST

Original text of this message