This Docs May Help You.
Also Use Following Code For Create Procedure.
You need the CREATE PROCEDURE system privilege to create a procedure in your own schema.
Open SQL*Plus from Windows and log on to your database.
From SQL*Plus, open your skeleton.sql file.
SQL*Plus loads the contents of your skeleton.sql file into the SQL*Plus buffer or memory area and presents the SQL*Plus command prompt:
1 CREATE OR REPLACE PROCEDURE skeleton
Execute the contents of the SQL*Plus buffer. Type a front slash and press <enter> like this:
SQL*Plus informs you the procedure has been created successfully and presents the SQL command prompt:
Procedure created.Malar, if this helps please login to Mark As Answer. | Alert Moderator