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

1 vote180 views1 answer
Import local sql into remote mysql
SQL
1 vote181 views2 answers
Mysql spring boot application.properties
SQL
0 vote149 views1 answer
Update row in sqlite python
SQL
8 votes195 views2 answers
Mysql grant all privileges to user from any host
SQL
6 votes192 views2 answers
Mysql convert timestamp to date
SQL
5 votes238 views1 answer
Mysql created at yesterdau
SQL
6 votes226 views5 answers
Oracle list tablespaces
SQL
1 vote235 views1 answer
How to give access to database in postgresql server to another user
SQL
1 vote233 views1 answer
Mysql show long running queries
SQL
1 vote203 views1 answer
Import sql file mysql commadn line
SQL