10046 trace.. bind question

From: Arul Ramachandran <contactarul_at_gmail.com>
Date: Sat, 23 Aug 2008 15:57:59 -0700
Message-ID: <1c1a62990808231557p4a7f83dexb56e12a4c5c6fcb5@mail.gmail.com>

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 ?





http://www.freelists.org/webpage/oracle-l Received on Sat Aug 23 2008 - 17:57:59 CDT

Original text of this message