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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arul Ramachandran
Sent: Saturday, August 23, 2008 6:58 PM
To: oracle-l@xxxxxxxxxxxxx
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

JPEG image

Other related posts: