RE: 10046 trace.. bind question
Date: Sun, 24 Aug 2008 12:24:59 +0200
oacdty=01 could mean varchar2 or nvarchar2. There is a huge difference between the two as if a bind value is passed as a nvarchar2 and the column datatype is a varchar2 then a implicit conversion is done, meaning that an index will not be used.
I have found that (at least on 9i) in case of a nvarchar2 datatype the bind value was not shown in the trace file (but the value length was).
Oracle Database Administrator
tel +32(0)3 451 23 82
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ric Van Dyke
Sent: zondag 24 augustus 2008 3:24
To: contactarul_at_gmail.com; oracle-l_at_freelists.org Subject: RE: 10046 trace.. bind question
Yes a 1 is a varchar2 data type. You can see these data types in the:
OracleŽ Call Interface Programmer's Guide,
10g Release 2 (10.2)
Part Number B14250-02
Chapter 3, Data Types, table 3-1.
What ever program is sending that in is not sending it as a number.Received on Sun Aug 24 2008 - 05:24:59 CDT