While executing Stored Procedure, I am getting the SQLSTATE 56098 error. I am using PREPARE statement when forming the dynamic query.Even I tried after changing the PREPARE statement name. But, the problem still persists. Until the day before Y'day , my app was working perfectly. I suddenly started getting this problem since then.
Following is an snapshot of my code
SET VAR1 = '44623X';
set srchStr = 'INSERT INTO SESSION.TABLE1 SELECT FIELD1 FROM TABLE2 WHERE FIELD2 = ' || '''' || VAR1 || '''';
prepare INSERTSTMT from srchStr;
How can I avoid this problem? I need an urgent solution.
Any suggestion would be appreciated.