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 vote337 views1 answer
Access refused mysql xampp server
SQL
0 vote366 views1 answer
Set classpath for mysql-connector.jar
SQL
2 votes398 views1 answer
Q operator in oracle
SQL
2 votes407 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote338 views1 answer
SQL get max per id
SQL
1 vote406 views1 answer
Last 24 HOUR data in mysql
SQL
2 votes382 views1 answer
Metasploit start postgresql
SQL
0 vote364 views1 answer
Mysql select smaller of two values
SQL
0 vote365 views2 answers
Dbms interview questions
SQL
4 votes374 views1 answer
For loop postgresql
SQL