Tech Discussed

Store Procedure invocation using BPEL Process in SOA Suite

In this post i will show you how to call and get Data using DB Adapter that we have developed previous post. You can check it out here Store Procedure with Out Parameter. In this Post we will develop a BPEL Process to Invoke this stored Procedure.

1) Drag and Drop a BPEL Process in component section. Following snaps shows how to do it. In input parameter select input parameter from XSD that is generated by your DB Adapter.

 2) For Output select output from xsd as shown below

3) After this click OK. Wire BPEL Process with DB Adapter. Your JDeveloper should look like this

4) Double click on EBSPricelistBPEL to open .bpel file. here you will apply little logic

5) Now drag and drop Invoke service from your right between receiveinput and replyoutput. Wire this with DB Adapter, A pop up will appear. give it a appropriate name and create input and output variable like this.

6) Click OK. Now drag and drop an Assign activity and below invoke, give it appropriate name. Your composite will look like this

7) Now Double Click on you AssignOut put activity. And apply the following mapping and then click ok

8) Now your composite is ready to deploy. Deploy it and then test using EM console it will show the Master and detail table data.

In my next post i will show you how to insert data from one Database to another and i will also show how to use mediator in BPEL and about transformation.

Posted

in

by

Muhammad Nasir

Tags:

Comments

One response to “Store Procedure invocation using BPEL Process in SOA Suite”

  1. Unknown Avatar
    Unknown

    when i am trying to deploy it shows following error

    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>
    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>

    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>
    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>

    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>
    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>

    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>
    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>

    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>
    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>

    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>
    <
    MDSInstance associated with the MDSSession: ADFApplication23
    MatadataStores accessed: FileMetadataStore : Metadata Path = C:UsersankeshAppDataRoamingJDevelopersystem12.1.3.0.41.140521.1008DefaultDomainstore/gmds/mds-soa
    PContext.getVersionContext() returns null.>

    i am using jdevloper 12c with bpel process 2.0