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.

Step 3

Select the Operation Type.

For example, here it is “Call a Store Procedure/Function”.

Step 4

Select the Procedure.

Step5

Drag Invoke activity in the BPEL flow and then Invoke the DB Adapter from it.

Step 6

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.

Step 7

Copy the function of ASSIGN_1 – this will copy the input value of BPEL process to input variable of Invoke activity.

Step 8

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