RE: 10046 trace.. bind question

From: Ric Van Dyke <>
Date: Sat, 23 Aug 2008 20:24:20 -0500
Message-ID: <>

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.    

[] On Behalf Of Arul Ramachandran Sent: Saturday, August 23, 2008 6:58 PM
Subject: 10046 trace.. bind question  

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

  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 ?




Received on Sat Aug 23 2008 - 20:24:20 CDT

Original text of this message