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

15 votes147 views4 answers
Create table if not exists sql
SQL
0 vote140 views1 answer
Check psql validity function
SQL
0 vote137 views1 answer
Pl sql constraint user function
SQL
0 vote164 views1 answer
How convert into in in sql query
SQL
0 vote155 views1 answer
Foreign key multiple columns
SQL
1 vote187 views1 answer
Select last row from SQL Table
SQL
5 votes141 views1 answer
Oracle get nls settings
SQL
18 votes139 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote128 views1 answer
Materialized view redshift
SQL
0 vote137 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL