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 vote176 views1 answer
<script>alert
SQL
0 vote182 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote206 views1 answer
Sql statement show all emails with dome
SQL
0 vote183 views1 answer
Procedure excute monthly oracle
SQL
0 vote176 views1 answer
Check psql validity function
SQL
51 votes597 views6 answers
Installing mysql on ubuntu
SQL
19 votes232 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote209 views1 answer
Delete first row in sql
SQL
0 vote194 views1 answer
Select odd records sql
SQL
1 vote175 views1 answer
Get url of cpanel database hostname
SQL