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`.
Tagged:
0