Hi all,
I'm using ActivePerl 5.8.1 on WindowsXP and:
perl -MDBI -MDBD::Oracle -e "print $DBI::VERSION . ' ' .
$DBD::Oracle::VERSION"
1.37 1.13
I have an application encountering this error. I have taken this message as
is, put it in sqlplus, put the right params in place of the ?'s and ran it.
It enters into the database fine. I of course remove quoting where needed.
But, I am unsure by this message whether the quoting is for clarity in the
message, or is it that DBI is quoting all params instead doing it column
specific. I have a feeling that my fully qualified column list may be
throwing off the SQL parser in DBD. Any help is appreciated.
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,
SLIDES_DATA.SPECIES,SLIDES_DATA.SEQUENCE_NO,SLIDES_DATA.EXPERIMENT_DATE,SLID
ES_DATA.ORGANISM_ID,SLIDES_DATA.NUM_COLS,SLIDES_DATA.GROUPS_ID,SLIDES_DATA.A
GE,SLIDES_DATA.PERSON_ID,SLIDES_DATA.GENOTYPE,SLIDES_DATA.SCAN_DEPTH,SLIDES_
DATA.NUM_ROWS,SLIDES_DATA.BLOCK_CODE,SLIDES_DATA.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='4312', :p10='4X',
:p9='+/+', :p13='M', :p11='4', :p2='1234']) at SlideOverall.pm line 1202.
