You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to use SQL query in BPM workflow.

Received Response


We have a business scenario where we would like to use SQL query in BPEL workflow and based on the result, we want to Reject or Approve the workflow.

We tried using the rule oraext:query-database in Skip Rule under Advanced tab. Attached is the document where I have used.

Content (please ensure you mask any confidential information):

Currently we are not using BPA's in our organization. We want to implement that, business want to route Approvals for BPA's on certain conditions. For that we need to execute sql query. For that I used oraext in BPM workflow using skip rule. It saved sucessfully but gave me we error while approving PO. Please advise me on this.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!