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

5 votes147 views2 answers
Get columns number sql
SQL
1 vote118 views1 answer
T-sql find object by name
SQL
0 vote163 views1 answer
Psql create usr
SQL
0 vote124 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote232 views1 answer
Sqlite woth cmake
SQL
0 vote144 views3 answers
Convert sql query to python pandas
SQL
0 vote84 views1 answer
Mysql find foreign key references
SQL
0 vote129 views1 answer
Rename view mysql
SQL
2 votes130 views1 answer
Date conversion in mysql column
SQL
2 votes124 views1 answer
Oracle virtual column
SQL