Timeline for How do you find where a stored procedure is used (in other stored procedures)
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2015 at 19:51 | comment | added | Mindaugas Riauba |
In this case one has to search for a package. DBA_DEPENDENCIES show us more like what will be invalidated if particular object is droped. So e.g. you can find what views references table.
|
|
| Jan 7, 2015 at 14:08 | comment | added | Peter Bagnall | This is helpful, and I can locate functions and procedures which are defined by a user, but I don't seem to be able to find FNs or SPs which are defined in a package. Any thoughts? | |
| Jan 7, 2015 at 13:33 | comment | added | Raj | This approach will not however work if you use dynamic sql. i.e. if you execute a procedure as part of dynamic sql. Otherwise dba_ or all_dependencies will work great. | |
| Jan 7, 2015 at 13:27 | review | Low quality posts | |||
| Jan 7, 2015 at 13:55 | |||||
| Jan 7, 2015 at 13:11 | history | answered | Mindaugas Riauba | CC BY-SA 3.0 |