call procedure in oracle code example
Example 1: procedure plsql
CREATE PROCEDURE nome_procedura [(parametri)] IS
Definizioni;
BEGIN
Corpo procedura;
END;
Example 2: procedures in pl sql
CREATE [OR REPLACE] PROCEDURE procedure_name
[(parameter_name [IN | OUT | IN OUT] type [, ...])]
{IS | AS}
BEGIN
< procedure_body >
END procedure_name;