how to see the procedure in oracle code example
Example: plsql find location of procedure
SELECT *
FROM SYS.DBA_DEPENDENCIES
WHERE REFERENCED_NAME = '<NAME_OF_PKG_OR_PROC_FUNC>' AND
REFERENCED_TYPE IN ('PACKAGE', 'PROCEDURE', 'FUNCTION');
SELECT *
FROM SYS.DBA_DEPENDENCIES
WHERE REFERENCED_NAME = '<NAME_OF_PKG_OR_PROC_FUNC>' AND
REFERENCED_TYPE IN ('PACKAGE', 'PROCEDURE', 'FUNCTION');