Search 800 + Posts

Oct 17, 2009

How to Create a BPEL process to insert data in Oracle Table table.

In this blog I will explain with Simple example How to Create a BPEL process to insert data in table.

Step -1 # In my example I have table with 26 columns , and requirement is to Insert all 26 columsn manually.Please note that by default the for any BPEL process as only 1 inpit variable.

Step -2 #  To design input for BPEL process that take 26 argument , design the XML Schema document with 26 Element and make sure that datatype of elements is same as the type of the columns in table where you want to Insert.

Below is the  XSD I have created for ,y test case.




Step -3 # Once XSD created , Import the schema that we have created above into BPEL process , as shown below.



Step -4 # - BPEL Process is Request Message as well as response Message.Request Message will has inputput  with 1 argument (by default). Assign your XML schema that you have imported to Request Message as shown below.



 

Step -5 # - BPEL process receive activity.







Step -6 # - Drag Database Adapter and configure it to insert /update data into table (26 columns).


NOTE - In case you need additional info. on how to config database adaptor , please refer my earlier blog on same subject.


 

In step 7 I have config database adapter to insert data into table so_order_info.This table has 26 column.
Please note that in above steps , we have configure the Request Message also woth a message with 26 input variables.



Step -7 # -  Add  the Transform activity in your BPEL Process . With Transform activity will define Mapping.



Step -8 # - Config the Transform activity.



Step -9 # - Map the Request Message Type Variable with the Input Variable of the Invoke activity (Invoke activity will call the database adapter).


 

Step -10 # - Add a Dummy Assign activity .This activity print the Order # that we have inserted into the so_order_info table.


 

Step -11 # - Complete Process.



Step -12 # -Compile/Deply and Run the Process.


NOTE - In case you need additional info. on how to config database adaptor , please refer my earlier blog on same subject.

2 comments:

  1. very good presentation , can I get source code for that .

    ReplyDelete
  2. Hi!

    It is ol dpresentations and I don't have source code for that now

    Thanks

    ReplyDelete