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

1 vote394 views1 answer
Delete dublicate rows sql
SQL
0 vote356 views1 answer
Mysql aspas simples
SQL
0 vote333 views1 answer
Convert sql server guid to varbinary
SQL
4 votes409 views4 answers
Check constraint in ms sql
SQL
0 vote297 views1 answer
Calculate discount from original price sql
SQL
0 vote359 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote351 views1 answer
Vagrant mysql downgrade version
SQL
0 vote359 views1 answer
How change the field place in mysql
SQL
0 vote346 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote355 views2 answers
Alter table add multiple columns mysql
SQL