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

0 vote98 views1 answer
Postgres get running query
SQL
-2 votes95 views1 answer
How to open database
SQL
34 votes96 views5 answers
Oracle alter table add column
SQL
23 votes102 views4 answers
Uninstall postgresql ubuntu
SQL
25 votes115 views4 answers
Metadata
SQL
1 vote107 views1 answer
Oracle select first row order by
SQL
0 vote113 views1 answer
To_date sql
SQL
0 vote55 views1 answer
Finish transaction sql
SQL
4 votes64 views1 answer
Oracle sleep
SQL
14 votes112 views1 answer
Oracle alter table add column not null
SQL