How To Execute Database Stored Procedures And Functions From ODI
Last updated on FEBRUARY 14, 2018
Applies to:Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.
*** Checked for ODI 11g compliance on 02-Jan-2013 ***
*** Relevance for ODI 12c confirmed on 21-Feb-2014 ***
How can database / RDBMS stored procedures be executed from Oracle Data Integrator (ODI)?
For Oracle, when using the "EXECUTE MY_SCHEMA.MY_PACKAGE.MY_PROCEDURE (MY_PARAM1, MY_PARAM2)" syntax to call a stored procedure from ODI, the following error message is signaled:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms