Apparently, the DBD driver is not guessing the column type correctly. Type
0 is not listed in the cheetah book. Haven't check the DBD or DBI code yet.
Since I'm using ActiveState PPD's for DBD::Oracle are not easily available
so I'm hoping if someone suggests upgrading DBD::Oracle they can also
provide the PPD :-)
-> prepare for DBD::Oracle::db (DBI::db=HASH(0x2d1dfcc)~0x2d202dc 'INSERT
INTO Slides_data ( slides_data_id, links_id,
SPECIES,SEQUENCE_NO,EXPERIMENT_DATE,ORGANISM_ID,NUM_COLS,GROUPS_ID,AGE,PERSO
N_ID,GENOTYPE,SCAN_DEPTH,NUM_ROWS,BLOCK_CODE,GENDER) VALUES (
slides_data_sq.nextval, links_sq.nextval , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ? )') thr#2243d4
dbd_preparse scanned 13 distinct placeholders
<- prepare= DBI::st=HASH(0x3f183fc) at SlideOverall.pm line 1201
-> execute for DBD::Oracle::st (DBI::st=HASH(0x3f183fc)~0x2e100c4
'Mouse' '098' 'Aug 05 2003 12:00AM' '098' '2' '1' 'TS01' '1' '+/+' '4X' '2'
'WK-012345-1' 'M') thr#2243d4
bind :p1 <== 'Mouse' (type 0)
bind :p1 <== 'Mouse' (size 5/6/0, ptype 7, otype 1)
bind :p2 <== '098' (type 0)
bind :p2 <== '098' (size 3/4/0, ptype 7, otype 1)
bind :p3 <== 'Aug 05 2003 12:00AM' (type 0)
bind :p3 <== 'Aug 05 2003 12:00AM' (size 19/20/0, ptype 7, otype 1)
bind :p4 <== '098' (type 0)
bind :p4 <== '098' (size 3/4/0, ptype 7, otype 1)
bind :p5 <== '2' (type 0)
bind :p5 <== '2' (size 1/2/0, ptype 7, otype 1)
bind :p6 <== '1' (type 0)
bind :p6 <== '1' (size 1/2/0, ptype 7, otype 1)
bind :p7 <== 'TS01' (type 0)
bind :p7 <== 'TS01' (size 4/5/0, ptype 7, otype 1)
bind :p8 <== '1' (type 0)
bind :p8 <== '1' (size 1/2/0, ptype 7, otype 1)
bind :p9 <== '+/+' (type 0)
bind :p9 <== '+/+' (size 3/4/0, ptype 7, otype 1)
bind :p10 <== '4X' (type 0)
bind :p10 <== '4X' (size 2/3/0, ptype 7, otype 1)
bind :p11 <== '2' (type 0)
bind :p11 <== '2' (size 1/2/0, ptype 7, otype 1)
bind :p12 <== 'WK-012345-1' (type 0)
bind :p12 <== 'WK-012345-1' (size 11/12/0, ptype 7, otype 1)
bind :p13 <== 'M' (type 0)
bind :p13 <== 'M' (size 1/2/0, ptype 7, otype 1)
dbd_st_execute INSERT (out0, lob0)...
!! ERROR: 1858 'ORA-01858: a non-numeric character was found where a
numeric was expected (DBD ERROR: OCIStmtExecute)'
<- execute= undef at SlideOverall.pm line 1202
1 -> FETCH for DBD::Oracle::st (DBI::st=HASH(0x2e100c4)~INNER
'ParamValues') thr#2243d4
error: 1858 'ORA-01858: a non-numeric character was found where a
numeric was expected (DBD ERROR: OCIStmtExecute)'
1 <- FETCH= HASH(0x2e10010)13keys at SlideOverall.pm line 1202
DBD::Oracle::st execute failed: ORA-01858: a non-numeric character was found
where a numeric was expected (DBD ERROR: OCIStmtExecute) [for statement
``INSERT INTO Slides_data ( slides_data_id, links_id,
SPECIES,SEQUENCE_NO,EXPERIMENT_DATE,ORGANISM_ID,NUM_COLS,GROUPS_ID,AGE,PERSO
N_ID,GENOTYPE,SCAN_DEPTH,NUM_ROWS,BLOCK_CODE,GENDER) VALUES (
slides_data_sq.nextval, links_sq.nextval , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ? )'' with params: :p5='2', :p6='1', :p3='Aug 05 2003 12:00AM',
:p12='WK-012345-1', :p7='TS01', :p1='Mouse', :p8='1', :p4='098', :p10='4X',
:p9='+/+', :p13='M', :p11='2', :p2='098']) at SlideOverall.pm line 1202.
-> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x2e100c4)~INNER)
thr#2243d4
error: 1858 'ORA-01858: a non-numeric character was found where a
numeric was expected (DBD ERROR: OCIStmtExecute)'
<- DESTROY= undef at SlideOverall.pm line 1170
-> rollback for DBD::Oracle::db (DBI::db=HASH(0x2d1dfcc)~0x2d202dc)
thr#2243d4
<- rollback= 1 at SlideOverall.pm line 1171
