Missing In and Out Parameter at index in procedure
I am writing my select query on command on source tab, say
A as A,
B as B
I am writing insert query in command on source tab.
insert into table(
It end with a error in target Missing In and Out Parameter at index 26
All columns are in caps.
put a DECLARE step before all. After that under my opinion it's better to put a TO_CHAR().
Try putting your variable in text mode and modify your filter into
TO_CHAR(LAST_UPDATE_DATE,'YYYYMMDDHHMI') >= TO_CHAR(#PROJ.P_EXTRACT_FROM_TS,'YYYYMMDDHHMI')In your operator if you click on variable which value do you see?