Call PL_SQL Procedure From BPEL
In this article let’s go throught the steps involved in calling a PLSQL procedure from BPEL.
Double click the screenshot for an enlarged image.
Step -1 Create a BEPL Application in JDeveloper 11g.
Make sure it is a Synchronous template.
Step – 2
Drag Database Adapter and configure it.
Select the Operation Type.
For example, here it is “Call a Store Procedure/Function”.
Select the Procedure.
Drag Invoke activity in the BPEL flow and then Invoke the DB Adapter from it.
BPEL Process is ready. To make this BPEL flow work, add a dummy Assign activity in the flow.
Assign_1 and Assign_2
Assign_1 – This will assign a value to the input variable of invoke activity.
Assign_2 – This will assign a value of the invoke activity to output variable of BPEL Flow.
Its a “dummy activity” because there is no input value process involved. For example, PL/SQL Procedure has one INSERT clause that just Inserts hard coded values into the table.
Input variable for Invoke activity.
Copy the function of ASSIGN_1 – this will copy the input value of BPEL process to input variable of Invoke activity.
Add Assign_2 and perform the COPY operation.
Step 9 – Complete Process
Step 10 – Deployment
Step 11 – Testing -1
Step 11 – Testing -2
Step 11 – Testing -3
Step 11 – Testing -4