Create Synonym for Stored Procedure in Oracle

The following is an example of CREATE SYNONYM for Oracle Stored Procedure.

Create Synonym Example For Stored Procedure

For example, you have created a stored procedure named proc_customer, and you want to create a synonym for that. Then your CREATE SYNONYM statement should be as below.

CREATE OR REPLACE SYNONYM syn_proc_customer for proc_customer;

You can give the same name to synonym as procedure's name.

CREATE OR REPLACE SYNONYM proc_customer for proc_customer;

Grant Permission For Synonym

GRANT EXECUTE ON syn_proc_customer TO SCOTT;

See also:

• Create Synonym Examples in Oracle