If this is the exact statement: -----8<----- update test set col1 = 'abc', col2 = 'def', col3 = 'ghi', col4 = '120' where col1 = 'xyz' -----8<-----
Then your problem likely stems from the fact that you're treating the value of col4 as a string rather than a number because you've surrounded it with quotes. Remove the quotes from the value for col4 and let us know if that works. Hope this helps... Gordon Dewis Production Officer Geography Division Statistics Canada (613)951-4591 -----Original Message----- From: Koen Gogne [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 3:24 AM To: dbi_users 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] ----------------------------------------------------
