A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example script below creates a stored procedure:

SQL> CREATE PROCEDURE Greeting AS

2 BEGIN

3 DBMS_OUTPUT.PUT_LINE('Welcome to globalguideline!');

4 END;

5 /

Procedure created.