How To Execute Database Stored Procedures And Functions From ODI (Doc ID 423812.1)

Last updated on JUNE 28, 2016

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 ***

Symptoms

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:

ORA-00900 : Invalid SQL statement

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms