How to Call Oracle Procedure with ODI

1.    How to Call Oracle Procedure

1.1    Main Steps

• Create procedure A in Oracle
• Create procedure in ODI to call A

1.1.1    Create Procedure A in Oracle

Create a procedure in Oracle with input and output parameters as below.

 

1.1.2    Create procedure in ODI to Call A

Create an ODI store procedure

 

Create a step to call Oracle store procedure

 

Can set input parameter with ODI variable as v_ProductCode := :sProductCode ( sProductCode is ODI variable)

1.2    Reference

How to use PL/SQL procedures and functions in ODI

http://odiexperts.com/how-to-use-plsql-procedures-and-functions-in-odi/