All Forums Database
umakathir 32 posts Joined 09/06
09 Nov 2006
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.

umakathir 32 posts Joined 09/06
09 Nov 2006

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.

You must sign in to leave a comment.