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

Dynamic Approvers in PR/PO BPM Approval with orcl:query-database-with-bindvar

We are using BPM Approval with XPATH (Dynamic Approval based on a SQL query). There are two options: 1. `orcl:query-database` and 2. `orcl:query-database-with-bindvar`. We learned from a customer thread that Oracle plans to deprecate `orcl:query-database` due to performance issues during approval retrieval, recommending the use of `orcl:query-database-with-bindvar`. However, switching to the bindvar option hasn't worked as expected; specifically, the supervisor hierarchy using `connect by prior` is not functioning in this method. Could you confirm if Oracle will deprecate `orcl:query-database` soon? Additionally, we need to understand the limitations of `orcl:query-database-with-bindvar`.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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