Create Synonym for Stored Procedure in Oracle

Create Synonym for Stored Procedure in Oracle

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

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: