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




Reply via email to