CODE EXAMPLE FOR SQL

oracle synonym procedure

-- Can be a table, package, procedure...
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_procedure;      
CREATE OR REPLACE PUBLIC SYNONYM syn_name FOR my_schema.my_procedure;

-- Through a dblink:
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_procedure@my_dblink;