Re: Viewing bind variable values in 10g - Any suggestions?
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: teijo.lallukka@xxxxxxxx
- Date: Fri, 7 Nov 2008 10:29:55 -0800
You may want to consider the OraSRP for use with trace files.
http://oracledba.ru/orasrp/
Works fairly well, and is free.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Thu, Nov 6, 2008 at 1:58 AM, Teijo Lallukka <teijo.lallukka@xxxxxxxx>wrote:
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
