I want to do a text search over all PL/SQL functions/procedures in my DB to see which code is calling a particular function. Is there a tool in SQL Developer for that, or a meta-table under the system schema storing function code? A textual dump of the schema would help as well.
Oracle 12c PL/SQL – How to Perform Textual Search Over All Code
oracleoracle-12coracle-sql-developerplsql
Related Question
- Expdp with metadata_only gives way too large dump. Why
- How to find where a stored procedure is used (in other stored procedures)
- Oracle: procedures+functions code base not overlapping package body code base
- Prevent COUNT() Subquery using window functions
- Oracle 12c – Alternative to CREATE TYPE with Read-Only Privileges
- How to See Original Text of Wrapped Function in Oracle 11g R2
Best Answer
Provided that the following is true:
1) The function is NOT in a package
2) The function call is NOT dynamic SQL
Then you can simply see what its dependencies are from dba_dependencies:
Otherwise, you can check dba_source:
To view the source for all objects for a schema: