I would check your date that you are inserting, it could be expecting a different format. What is you NLS_DATE_FORMAT set to?
Here is the output from oerr. oerr ora 1858 01858, 00000, "a non-numeric character was found where a numeric was expected" // *Cause: The input data to be converted using a date format model was // incorrect. The input data did not contain a number where a number was // required by the format model. // *Action: Fix the input data or the date format model to make sure the // elements match in number and type. Then retry the operation. Thanks, Sam Gold -----Original Message----- From: Tim Harsch [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:55 PM To: Tim Harsch; [EMAIL PROTECTED] Subject: Re: DBD SQL parser failing? It is not fully qualified names throwing off the parser because I remove table names from column list and: 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='231', :p10='4X', :p9='+/+', :p13='M', :p11='2', :p2='1231321']) at SlideOverall.pm line 1202. ----- Original Message ----- From: "Tim Harsch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 05, 2003 10:44 AM Subject: DBD SQL parser failing? > 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. >
