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 vote218 views2 answers
How to update the multiple rows in sql
SQL
25 votes219 views1 answer
Mysql grant all privileges to a user
SQL
0 vote228 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
2 votes219 views1 answer
Oracle list grants on procedure
SQL
2 votes235 views1 answer
Mysql change data type of column
SQL
0 vote219 views1 answer
Sql delimiter to columns
SQL
3 votes216 views2 answers
How to View column names of a table in SQL
SQL
1 vote230 views2 answers
Drop table if exists test
SQL
7 votes221 views1 answer
Safe mode mysql
SQL
0 vote223 views1 answer
Error code 1215 cannot add foreign key constraint
SQL