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. arp mac aging best practices
  2. anything
  3. B8000_A422_000_085_140402_WW_WIFI
  4. LinkedIn messages who dents them
  5. apple tv hulu no signal
  6. A422_000_085_140402_WW_WIFI
  7. sapjco3 Connect to SAP gateway failed
  8. LFJ9
  9. W2AS
  10. describecy7
Copyrights 2019 Fcffair BigData Resource, All rights reserved