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] ----------------------------------------------------
