Oracle Database Discussions

I am trying to write a small tool that will extract sql statements along with the bind variables inserted into the sql statement from a trace file.

The issue is that I have found that some bind variables dont have a value (7, 8, 10, 11, 12 have no value in the trace below). How can that be? Is it somehow just not cincluding then? I know that 1 may be a clob but others are not (term_wrk_3_ls may be a clob).

I am so close to getting this to work so any help would be great.

PARSING IN CURSOR #57 len=228 dep=0 uid=1353 oct=2 lid=1353 tim=5225090257 hv=321212596 ad='4b703b2c'
insert into BATCH_AFTER.CD_PREM_DDCTN_DTL ( o__num, o__st, o__edn, o__kdn, o__edx, o__kdx, o__kdxa, term_wrk_3_ls, strt, l_contract, l_base, pbd_list, risk_list ) values ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13 )
END OF STMT
PARSE #57:c=0,e=7127,p=0,cr=90,cu=0,mis=1,r=0,dep=0,og=0,tim=5225090253
BINDS #57:
bind 0: dty=1 mxl=32(14) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=360 offset=0
bfp=05c3f208 bln=32 avl=13 flg=05
value="UGVLC001UiH10"
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=32
bfp=05c3f228 bln=22 avl=03 flg=01
value=2001
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=56
bfp=05c3f240 bln=22 avl=04 flg=01
value=73049
bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=80
bfp=05c3f258 bln=22 avl=04 flg=01
value=73049
bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=104
bfp=05c3f270 bln=22 avl=04 flg=01
value=999999
bind 5: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=128
bfp=05c3f288 bln=22 avl=04 flg=01
value=999999
bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=152
bfp=05c3f2a0 bln=22 avl=04 flg=01
value=999999
bind 7: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=21 oacfl2=10 size=0 offset=176
bfp=05c3f2b8 bln=32 avl=00 flg=01
bind 8: dty=2 mxl=22(00) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=208
bfp=05c3f2d8 bln=22 avl=00 flg=01
bind 9: dty=1 mxl=32(14) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=232
bfp=05c3f2f0 bln=32 avl=13 flg=01
value="aRKfV001UiF12"
bind 10: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=21 oacfl2=10 size=0 offset=264
bfp=05c3f310 bln=32 avl=00 flg=01
bind 11: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=21 oacfl2=10 size=0 offset=296
bfp=05c3f330 bln=32 avl=00 flg=01
bind 12: dty=1 mxl=32(00) mal=00 scl=00 pre=00 oacflg=21 oacfl2=10 size=0 offset=328
bfp=05c3f350 bln=32 avl=00 flg=01
EXEC #57:c=0,e=2130,p=1,cr=1,cu=3,mis=0,r=1,dep=0,og=4,tim=5225092445