My Oracle Support Banner

How To Execute Database Stored Procedures From Jython Scripts In ODI (Doc ID 424207.1)

Last updated on JANUARY 07, 2019

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 11.1.1.9.99 [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.



Goal

Is it possible to call Database Stored Procedures from Jython? If so, what is the syntax?

Solution

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
Goal
Solution
 ODI 11g
 ODI 10g
 Example with IN and OUT parameters
 Example with use of an existing Connection
 Example with use of Cursor to navigate through the Result Set
References

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