Hey,
There has been a prior discussion on this exception but I could not find a
solution to it in the discussion threads. I would appreciate any help on this.
I have the following update statement:
UPDATE SRM_CM_DA_CLOB
SET CREATED_BY =?,
DA_CLOB =?,
UPDATED_BY =?,
COMPANY_ID =?,
UPDATE_DATE = ? ,
PROXY_MODIFIER =?,
ROW_VER_NUMBER=ROW_VER_NUMBER+1
WHERE DA_CLOB_ID=? AND ROW_VER_NUMBER=?
With the values:
Set long(1,50000)
Set String(2,asdfasdr)
Set long(3,50000)
Set long(4,50000)
Set Timestamp(5,2004-05-04 18:40:42.058)
Set long(6,50000)
Set long (7:140000)
Set long(8:0)
And I get the following exception:
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3016]: Invalid numeric constant
The table definition is as follows:
DA_CLOB_ID :FIXED(19)
CREATED_BY :FIXED(19)
DA_CLOB :LONG UNICODE
UPDATED_BY :FIXED(19)
COMPANY_ID :FIXED(19)
CREATE_DATE :TIMESTAMP(26)
UPDATE_DATE :TIMESTAMP(26)
PROXY_CREATOR : FIXED(19)
PROXY_MODIFIER : FIXED(19)
ROW_VER_NUMBER : INTEGER(10)
I would appreciate any help on it.
I do not know which column is causing the error but I assume it is the timestamp from
your conversations.
Kind Regards
Sumit Agarwal
Developer, Collaborative Commerce
3410 Hillview Avenue
Palo Alto, CA 94061
PH - 650 320 3103
