Oracle SOA- Calling stored procedure via BPEL
In my this post, I'll share the details how can you insert a new line character in your XPath expression during assignment (assign activity in BPEL). So let's get started-
In this post, I am using BPEL2.0, JDEV11g, Oracle Database12c
1. Create a new SOA composite application and add a new soa peoject- Calling SPViaBPEL
2. Drag a new database adapter in composite swim lane (external references)
3. Start DB adapter configuration as below-
5. Select existing database connection to oracle database or create a new then select the same.
Make sure your JNDI configuration exists in weblogic server outbound connection pool.
Please refer https://k10middleware.blogspot.in/2017/05/oracle-weblogic-server-new-data-source.html for creating a new data source in weblogic.
6. Select schema then procedure from browse option(packge.procedure_name)
7. Continue with default values.
8. Finish it.
9. Create a new BPEL process with new schema(with input/output elements) & wire with database adapter.
10. Check your bpel. Drag an invoke activity and wire with DB adapter service. Then add 1 assign activities above & below the invoke activities respectively.
Make sure you create input/output variables for invoke activity.
11. Perform assignment before service call.
12. Perform assignment after service call.
13. Done. Just save it, deploy and test the service.
Comments
Post a Comment