This is because one of the fields is numeric, and you are quoting it, or inserting text into a numeric field, possibly. If you used placeholders, you would of prevented this error.
Ilya -----Original Message----- From: Koen Gogne To: dbi_users Sent: 1/11/02 1:24 AM Subject: ORA-01722 hi, I'm having this strange problem on my Oracle8 DB when using the DBI: I want to update some table 'test' with discription : col1 varchar2(255) col2 varchar2(255) col3 varchar2(255) col4 number(8) when I try to perform following update-statement update test set col1 = 'abc', col2 = 'def', col3 = 'ghi', col4 = '120' where col1 = 'xyz' I get a ORA-01722 error from the DBI But when I use SQLplus to perform the exact same update-statement, I get NO error When trying to insert a new entry on table test I never get an error, not in DBI, not in SQlplus. I know ORA-01722 has something to do with conversionproblems (from number to char for instance, or when joining two columns with different type). But in this case I don't do joins, I'm not trying to convert anything. Does anyone have an idea on how to solve this ? ---------------------------------------------------- KOEN GOGNE [EMAIL PROTECTED] ----------------------------------------------------
