Search text in Oracle DB; Returns all types of Oracle function;

 Select * from ALL_SOURCE  where TEXT LIKE '%Approval%'  

Call a procedure on different DB; DB Link; Oracle

https://www.oracletutorial.com/oracle-administration/oracle-create-database-link/

Make sure grants are given to the user where the call is being made from.

How to call a procedure- :


/**
begin 

package procedure@dblink


end
**/