10046 trace.. bind question

  • From: "Arul Ramachandran" <contactarul@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 23 Aug 2008 15:57:59 -0700

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

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 ?



Other related posts: