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 vote180 views1 answer
Manage Database in MySQL
SQL
0 vote185 views1 answer
Oracle list user locked
SQL
10 votes164 views2 answers
Mysql remove only_full_group_by permanently
SQL
3 votes200 views1 answer
Oracle nextval insert
SQL
0 vote194 views1 answer
Drop domain postgresql
SQL
1 vote149 views2 answers
Sql for date greater than
SQL
0 vote156 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote162 views1 answer
Sql select inside select sub query
SQL
0 vote239 views1 answer
Setting default value for Boolean data type in SQL
SQL
1 vote197 views1 answer
Postgres select as csv
SQL