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 vote123 views1 answer
Sql view index
SQL
15 votes137 views2 answers
How to drop database name in postgresql
SQL
2 votes132 views1 answer
Mysql last 7 days including today
SQL
0 vote129 views1 answer
Tsql delete all rows
SQL
0 vote135 views1 answer
Sql express database size limit
SQL
0 vote136 views1 answer
Get substract count sql
SQL
1 vote151 views1 answer
Postgresql filter on
SQL
0 vote134 views1 answer
Mariadb select limit offset
SQL
0 vote166 views1 answer
Mysql select random rows large table
SQL
-1 vote168 views2 answers
Sql search all tables for attributes
SQL