1.How to Create a DBAdaptor (Partner link) in BEPL to call a PL/SQL procedure .
In case visibility is not clear , double click the screen Shot.
Lots of such examples available at www.oracle.com
Step -1 Create a BEPL Application in JDev11g.
Make Sure it is Synchronous template.
Step - 2
Drag Database Adapter and configure it.
Select the Operation Type.
In my example 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.
Our Process is ready , Now to make this BPEL flow work , I add to dummy Assign activity in the flow.
Assign_1 and Assign_2
Assign_1 - This will assign the input variable to Input variable of Invoke activity.
Assign_2 - This will assign the output variable of Invoke activity to output variable of BPEL Flow.
Why I called them as dummy activity , because I am not using values input to this process any where .
My example PL/SQL Procedure has one INSERT Clause that just Insert hardcoded values in table.
I/p variable for Invoke activity.
Copy functionof ASSIGN_1 , it just copy input variable of BPEL process to Input variable of Invoke activity.
Add Assign_2 and perform COOPY operation.
Step 9 - Complete Process
Step 10 - Deployment
Step 11 - Testing -1
Step 11 - Testing -2
Step 11 - Testing -3
Step 11 - Testing -4