Hi,
Im trying to load data from several Oracle DB datasets to an Oracle table and I get the following error:
"ODI-1228: Task CAPEX (Export) fails on the target ORACLE connection DEV Staging Area.
Caused By: java.sql.SQLException: Missing IN or OUT parameter at index:: 3"
This error appears when loading data from each dataset temporary tables (C$_0CAPEX...C$_4CAPEX) to a temporary general table (C$_CAPEX). The LKM that im using is SQL to SQL
I think the problem might be related to "target_code" generated by ODI on this step,
insert into C$_CAPEX
(
CUENTA, PERIODO, ANIO, ESCENARIO, F_SOLICITANTE, PROYECTO0, VERSION, AFC, DATA
)
values
(
:CUENTA, :PERIODO, :SP2F.Anio, :ESCENARIO, :F_SOLICITANTE, :PROYECTO0, :VERSION, :AFC, :DATA
)
Please share your valuable answers.
Regards