PL- SQL Procedure in ODI (Oracle Data Integrator)

PL- SQL/ Oracle/ Stored Procedure in ODI are used to execute statements from multiple Technologies like Oracle, Java Script, Python, Java Bean, Shell etc. In this example, we will create a procedure using Oracle PL SQL technology in ODI. Procedure is pretty simple and just adds a few rows in a table. But then, idea behind is only to show how to create the procedure. So let’s see the structure of our table:

Below are the steps:
1. Open the project folder where the procedure is to be created.
2. Right-click on Procedures and select ‘New Procedure’.

3. In the new window, give an appropriate procedure name, uncheck ‘Multi-Connections’ and select Target Technology as Oracle.

4. Go to the ‘Tasks’ tab and create a new Task by clicking on the + icon.
5. Give an appropriate ‘Task name’.
6. In the properties window, Expand Target Command and select the Logical Schema of your Oracle DB.

7. Open the Target Command field of the task.
8. Write the PL-SQL procedure and save the procedure. And this completes the creation of Procedure in ODI.

9. The statements are committed automatically when the procedure is run.

Related Posts:

Web Service Invocation from ODI
ODI Reverse Engineering

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

Check out the Amazon Deals of the day based on your interests..