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

5 votes263 views1 answer
Mysql get last day of month
SQL
1 vote283 views1 answer
Mysql get domain from url
SQL
0 vote277 views1 answer
Mysql in clausule string array
SQL
6 votes321 views2 answers
Install psql mac
SQL
0 vote257 views1 answer
Sql select column names starting with
SQL
11 votes290 views3 answers
How to get last row of table in sql
SQL
11 votes263 views2 answers
MySQL DISTINCT
SQL
0 vote307 views1 answer
Différence entre deux dates sql oracle
SQL
7 votes259 views2 answers
Get database size mysql
SQL
1 vote283 views1 answer
How to delete data from sql database in android
SQL