Perhaps your right. The date format for this database is set to mimic Sybase's default because of a conversion to Oracle some years back. It is set as the default for all sessions in the init.ora file. So, in Sql*plus this is not a problem. Why would it be a problem in this DBI session?
----- Original Message ----- From: "Gold, Samuel (Contractor)" <[EMAIL PROTECTED]> To: "'Tim Harsch'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 05, 2003 11:11 AM Subject: RE: DBD SQL parser failing? > 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. > > > > >
