RE: 10046 trace.. bind question

Yes a 1 is a varchar2 data type. You can see these data types in the:  

Oracle(r) 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.  

Ric Van Dyke

Hotsos Enterprises

Hotsos Symposium 2009 dedicated to performance and nothing but performance

March 8 - 12, 2009 in Dallas, Texas

Be there.    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Arul Ramachandran Sent: Saturday, August 23, 2008 6:58 PM
To: oracle-l_at_freelists.org
Subject: 10046 trace.. bind question  

From the 10046 trace, I am trying to check the datatype of the bind:

 Bind#0
  oacdty=01 mxl=128(57) mxlc=00 mal=00 scl=00 pre=00   oacflg=05 fl2=1000000 frm=01 csi=871 siz=128 off=0   kxsbbbfp=ffffffff7b241690 bln=128 avl=19 flg=05   value="1328421295250160905"

Here, oacdty=01, and value within double quotes tells me that it is varchar2. Whereas, I am expecting the variable type in the code to be declared as number.

Does oacdty=01 mean the type is varchar2 ?

Thanks,

-- 
Arul





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