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

2 votes192 views2 answers
Oracle no data found error code
SQL
5 votes210 views1 answer
Mysql select greater than yesterday
SQL
-1 vote212 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote211 views1 answer
Postgresql contains
SQL
18 votes196 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
9 votes197 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote222 views1 answer
Sqlite version check
SQL
0 vote199 views1 answer
Dbms_output sql developer
SQL
11 votes230 views5 answers
Laravel db facade
SQL
0 vote148 views1 answer
Bigquery information_schema schema all columns
SQL