Missing In and Out Parameter at index in procedure

Advertisement
November 30

Hi,
I am writing my select query on command on source tab, say
select
A as A,
B as B
from table
I am writing insert query in command on source tab.
insert into table(
A,
B
values
:A,
:B
It end with a error in target Missing In and Out Parameter at index 26
All columns are in caps.
Please help
Regards,
Prerna

Advertisement

Replay

Hi,
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?

View 8 Replies

Tags:

  1. FcffairBigDataResource
  2. how to make my bt id as a primary bt id
  3. L7EN
  4. 8QYE
  5. tonightyeq
  6. 9J18
  7. within6fx
  8. suitahz
  9. influencev66
  10. neededloh
Copyrights 2019 Fcffair BigData Resource, All rights reserved