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