CREATE PROCEDURE
CREATE [OR REPLACE] PROCEDURE [schema
.]procedure_name
[(argument
[IN | OUT | IN OUT]datatype
[,argument
[IN | OUT | IN OUT]datatype
.)] {IS | AS}pl/sql_subprogram
Creates a standalone stored procedure ( procedure_name).
Specifies that if the procedure exists, it is to be replaced.
Specifies the name of an argument to the procedure.
Specifies that a value must be supplied for argument when calling the procedure.
Specifies that the procedure will pass a value for argument back to the calling environment.
Specifies that a value must be supplied for argument when calling the procedure, and that the procedure will pass a value for argument back to the calling environment.
Specifies the procedure code, written in PL/SQL. You must specify either the IS or AS keyword.