Oracle 查找对utl_mail的引用

create or replace procedure p is
begin
  dbms_output.put_line(dbms_utility.get_time());
end p;
/

select * from user_source
where  upper(text) like '%DBMS_UTILITY%';

NAME               TYPE       LINE  TEXT                                                           
DISPLAY_BACKTRACE  PROCEDURE  4       DBMS_OUTPUT.put_line(DBMS_UTILITY.format_error_backtrace);
  
P                  PROCEDURE  3       dbms_output.put_line(dbms_utility.get_time());

select * from user_dependencies
where  referenced_name = 'DBMS_UTILITY';

NAME               TYPE       REFERENCED_OWNER  REFERENCED_NAME  REFERENCED_TYPE  REFERENCED_LINK_NAME  SCHEMAID  DEPENDENCY_TYPE  
DISPLAY_BACKTRACE  PROCEDURE  PUBLIC            DBMS_UTILITY     SYNONYM                                70        HARD             
P                  PROCEDURE  PUBLIC            DBMS_UTILITY     SYNONYM                                70        HARD             
复制