Stored procedure sql

-- without parameters; create
CREATE [OR ALTER] PROCEDURE <pname>
AS
BEGIN
<PROCEDURE BODY/ STATEMENTS>
END

-- call procedure
EXECUTE / EXEC <pname>;
(OR)
EXECUTE / EXEC <pname> VALUE / (S)

Stored procedure sql

-- without parameters; create
CREATE [OR ALTER] PROCEDURE <pname>
AS
BEGIN
<PROCEDURE BODY/ STATEMENTS>
END

-- call procedure
EXECUTE / EXEC <pname>;
(OR)
EXECUTE / EXEC <pname> VALUE / (S)

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;

What is a stored procedure

SQL Stored Procedure

-1

Similar codes

2 votes131 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote150 views1 answer
Vbscript clean up ADODB.Recordset
SQL
-1 vote216 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote171 views5 answers
Right join
SQL
0 vote145 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote143 views1 answer
Laravel eloquent get generated sql
SQL
6 votes150 views3 answers
Date_trunc postgres
SQL
0 vote157 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes135 views1 answer
Cast string to datetime mysql
SQL
0 vote130 views2 answers
Mysql two column combination unique
SQL