SQL Stored Procedure

About

A SQL Stored procedure is a sql procedure that is

• stored in the database.
• accessible by name and parameters

Management

Creation

You create a stored procedure with a SQL DML Request that contains the SQL statements

• CREATE PROCEDURE
• or CREATE OR REPLACE PROCEDURE

Execution

You execute a SQL stored procedure with a SQL DML Fetch.

Every database has its own syntax to call a procedure. See the section_support_below

But generally the database accepts JDBC escape syntax and a procedure can be called as follow for most of the database:

{call <procedure_name> [(<argument-list>)]}

or, where a procedure returns a result parameter:

{? = call <procedure_name> [(<argument-list>)]}

Example:

{ CALL do_db_maintenance() }

Support

Database

Stored procedures are supported by most DBMSs, but there is a fair amount of variation in their syntax and capabilities

Parameterized statement

We support procedure execution with parameters