Oracle procedure teamplate

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

4 votes338 views2 answers
Sql select except null
SQL
6 votes341 views2 answers
Find mysql version linux
SQL
0 vote294 views1 answer
How to set field to null in sql
SQL
0 vote338 views1 answer
Enable full text search mysql
SQL
0 vote361 views1 answer
Exit psql
SQL
0 vote371 views1 answer
C# execute transact sql
SQL
0 vote344 views1 answer
Why we have to set the password for my sql server
SQL
0 vote362 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote400 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote377 views1 answer
How to check rollback status in oracle
SQL