How to Create Procedure in Oracle SQL Developer?

How to Create Procedure in Oracle SQL Developer?

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.

In Oracle SQL Developer, follow these steps to create a Procedure.

  1. Navigate to the connections panel and expand the schema node in which you want to create a procedure.
  2. You will see the list of object types, then click on the Procedure node and do the right click on it.
  3. From the shortcut menu, click on the New Procedure option as shown below.

create procedure in oracle sql developer

  1. Then a Create Procedure window will appear.
  2. Specify procedure name in Name field.
  3. Then specify parameters for the procedure if any, as shown below.

procedure parameters in oracle sql developer

  1. Then click on the OK button, and the procedure will open in the editor window. There you can add the code in the procedure body. Below is an example.
CREATE OR REPLACE PROCEDURE NEWP 
(
P_EMPNO IN VARCHAR2 
, P_ENAME OUT VARCHAR2 
) AS 
BEGIN
NULL;
END NEWP;

See also: