RE: Bind values missing from SQL trace

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

--
http://www.freelists.org/webpage/oracle-l