skip to main content
SQL Escape Sequences : Procedure Call Escape Sequences
 

Procedure Call Escape Sequences

A procedure is an executable object stored in the data store. Generally, it is one or more SQL statements that have been precompiled.
The ODBC and JDBC Clients use the following escape sequence for calling a procedure:
{[?=]call procedure-name[([parameter][,[parameter]]...)]}
where:
procedure-name is the name of a stored procedure. You can call stored procedures with or without the schema name qualification.
parameter is a stored procedure parameterThe ODBC JDBC driver uses the following escape sequence for calling a procedure:
{[?=]call procedure-name[([parameter][,[parameter]]...)]}
where:
procedure-name is the name of a stored procedure. You can call stored procedures with or without the schema name qualification.
parameter is a stored procedure parameter.