Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle ODI - Missing IN or OUT parameter at index:: 1 using ODI date variable.

Anuj MarwahaMay 3 2016 — edited May 4 2016

I have defined a variable named LASTUPDATE (Alpha Numeric type) and this variable is used for storing date. I have assigned it a default value of '01-JAN-1900 00:00:00'. This variable is being used in Interface Filter condition for column Last Update Date where the filter condition is LAST_UPDATE_DATE >= TO_DATE('#LASTUPDATE','DD-MON-YYYY HH24:MI:SS').

This variable and Interface is used in a package. I have dropped this variable to Package and its type is set to "Set Variable" and given a default value '01-JAN-2000 00:00:00' and then Interface is called. However When I run this ODI project, it fails at interface step and gives below error.

ODI-1228: Task Test Interface (Integration) fails on the target ORACLE connection EBS_SWMDMDEV.

Caused By: java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Please suggest any solution.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2016

Added on May 3 2016

#business-intelligence-applications, #data-integrator, #system-management-and-integration

4 comments

3,285 views