Press "Enter" to skip to content

How to Create Procedure in Oracle SQL Developer?

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: