A constant value in a query is not valid for column A_TKN_PTC_WK

Database

A constant value in a query is not valid for column A_TKN_PTC_WK

I am getting run time error while executing my SP named as MainLeavecal "Failure 3520 MainLeaveCal:A constant value in a query is not valid for column A_TKN_PTC_WK"

I am using dynamic sql for the update statement and my update statement is given below:
-----------
CALL DBC.SysExecSQL('UPDATE FMA_DDBO.TFMA170_PRDPTCSTA SET
A_TKN_PTC_WK = ' || :intTakenWeeks ||
', A_TKN_PTC_DAY = ' || :intTakenDays ||
', A_TKN_PTC_HR = ' || :intTakenHours ||
', A_TKN_PTC_MTE = ' || : intTakenMinutes ||
', A_AVL_PTC_WK = ' || : intAvailableWeeks ||
', A_AVL_PTC_DAY = ' || : intAvailableDays ||
', A_AVL_PTC_HR = ' || : intAvailableHours ||
', A_AVL_PTC_MTE = ' || : intAvailableMinutes ||
' , T_CAL_PTC = CURRENT_TIMESTAMP ' ||
', I_USR_UDT_RCD = ' || : ERNO ||
' WHERE I_LVE_EVT IN (' || : strLveEvts || ') AND I_TYP_PTC = ' || : prdTyp);
------------

If intTakenWeeks has null value, whether we will get this error?
Please anyone help me for my urgent request.

Thanks in advance.

1 REPLY

Re: A constant value in a query is not valid for column A_TKN_PTC_WK

I am all set now.
Actually, my table field 'A_TKN_PTK_WK' has the data type of Decimal (2,0) and it was trying to store 119.0 and throws the error.