Procedure syntax

CREATE PROCEDURE procedure_name
AS
sql_statement
GO;

Sql procedure

CREATE OR REPLACE PROCEDURE my_scheme.my_procedure(param1 IN VARCHAR2) IS
    cnumber NUMBER;
BEGIN
    cnumber := 10;
    INSERT INTO my_table (num_field) VALUES (param1 + cnumber);
    COMMIT;
EXCEPTION
    WHEN OTHERS THEN
        raise_application_error(-20001, 'An error was encountered - '
            || sqlcode || ' -ERROR- ' || sqlerrm);
END;

Similar codes

0 vote202 views1 answer
T-sql check if data exists
SQL
1 vote198 views2 answers
Mysql join two tables
SQL
1 vote222 views2 answers
Mysql limit offset
SQL
2 votes228 views1 answer
Metasploit start postgresql
SQL
6 votes204 views1 answer
Phpmyadmin password root
SQL
0 vote201 views1 answer
Oracle archivelog usage
SQL
0 vote203 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote200 views2 answers
Postgres copy table from one schema to another
SQL
1 vote168 views1 answer
Mysql collation
SQL
2 votes191 views1 answer
Date_format for time sql
SQL