1CREATE OR REPLACE PROCEDURE my_scheme.my_procedure(param1 IN VARCHAR2) IS
2 cnumber NUMBER;
3BEGIN
4 cnumber := 10;
5 INSERT INTO my_table (num_field) VALUES (param1 + cnumber);
6 COMMIT;
7EXCEPTION
8 WHEN OTHERS THEN
9 raise_application_error(-20001, 'An error was encountered - '
10 || sqlcode || ' -ERROR- ' || sqlerrm);
11END;