My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2018

Applies to:

Oracle Data Integrator - Version 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:

ORA-00900 : Invalid SQL statement


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.