RE: Bind values missing from SQL trace
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Thu, 16 Aug 2007 13:01:11 -0500 (CDT)
Yup, these are expected values for dty, at least in 10gR1:
http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10779/oci03typ.htm#422443
(Or http://tinyurl.com/ywefss for the wrapped-line impaired)
Rich
> Okay, I tested it out and here is what I found:
>
> 1) Yes, dty=96 for CHAR & NCHAR, dty=1 for VARCHAR2 & NVARHCAR2 (in my
> 10.2.0.2 trace file it's reported as oacdty)
> 2) In 10.2.0.2, the same problem exists - NCHAR and NVARCHAR2 bind
> variable values are not shown in the 10046 trace file
> 3) The bind variable values ARE captured in v$sql_bind_capture
>
> The details of my testing are shown below.
>
> Regards,
> Brandon
--
//www.freelists.org/webpage/oracle-l
Other related posts:
