Procedure syntax

CREATE PROCEDURE procedure_name
AS
sql_statement
GO;

Sql procedure

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

0 vote162 views1 answer
Mysql convert charset
SQL
10 votes200 views2 answers
What is database
SQL
0 vote247 views1 answer
Shortcut run sql pgadmin
SQL
3 votes225 views1 answer
Query less than datetime sql
SQL
4 votes190 views2 answers
Oracle unlock account
SQL
1 vote160 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote192 views1 answer
Sql and
SQL
2 votes158 views1 answer
Update with join sql server
SQL
0 vote174 views1 answer
Guid string to binary better
SQL
0 vote165 views1 answer
Oracle list proxy users
SQL