Re: How to interpret date values in a trace file?

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 26 Jan 2007 18:08:25 -0800
Message-ID: <1169863705.833962.152660@v33g2000cwv.googlegroups.com>

On Jan 26, 5:35 pm, wagen..._at_yahoo.com wrote:
> Bind#5
> oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=00 pre=00
> oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=352
> kxsbbbfp=2a973b6d38 bln=11 avl=11 flg=01
> value=
> Dump of memory from 0x0000002A973B6D38 to 0x0000002A973B6D43
> 2A973B6D30 1C0A6A78 1520130F [xj.... .]
> 2A973B6D40 974075C1 [.u@.]
> Bind#6
> oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=00 pre=00
> oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=368
> kxsbbbfp=2a973b6d48 bln=11 avl=11 flg=01
> value=
> Dump of memory from 0x0000002A973B6D48 to 0x0000002A973B6D53
> 2A973B6D40 1A016B78 1520130F [xk.... .]
> 2A973B6D50 034075C1 [.u@.]
>
> Thanks for any help/pointers.
> wagen

Hi,

Are you sure you are mapping the binds correctly? Yours looks more like an object bind.

See below...

---

PARSING IN CURSOR #1 len=49 dep=1 uid=58 oct=3 lid=58 tim=1142444464038596 hv=1681858622 ad='29a84abc' SELECT * FROM MYDATE WHERE D BETWEEN :B2 AND :B1 END OF STMT
PARSE
#1:c=1000,e=15690,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,tim=1142444464038582

---

BINDS #1:
kkscoacd
 Bind#0
  oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00   oacflg=03 fl2=1206001 frm=00 csi=00 siz=16 off=0   kxsbbbfp=b72e9184 bln=07 avl=07 flg=05   value="1/26/2007 16:10:51"
 Bind#1
  oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00   oacflg=03 fl2=1206001 frm=00 csi=00 siz=0 off=8   kxsbbbfp=b72e918c bln=07 avl=07 flg=01   value="1/26/2007 18:34:51"
EXEC
#1:c=7998,e=36785,p=0,cr=8,cu=0,mis=0,r=0,dep=1,og=1,tim=1142444464075543

Notice the datatype is 12 (my table had a date datatype, as did the bind), whereas yours is 180.

HTH, Steve Received on Fri Jan 26 2007 - 20:08:25 CST