Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How/where to search all APEX application sql?

Aaron L.Apr 26 2021

When we change a package/function/procedure, we search the all_source view in SQL Plus to see where the function is called. Is there a table/view in APEX that we can search in that will show us all the places a function is called?
Example on how we search source:
SELECT owner||'.'||name,text
FROM all_source
WHERE upper(text) like '%MY_PACKAGE.MY_FUNCTION%';
Can we search one of the apex_190200.wwv_flow tables to see this information?
We can search in the builder for each application, but we are getting a lot of applications and not everyone in our department knows how to use that program.

This post has been answered by Egyed József on Apr 26 2021
Jump to Answer
Comments
Post Details
Added on Apr 26 2021
3 comments
2,322 views