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




Reply via email to