8. Understanding JDBC Connectivity : JDBC Implementation Considerations : Database Procedures
 
Share this page                  
Database Procedures
Database procedures are supported through the JDBC CallableStatement interface. The JDBC Driver supports the following database procedure syntax.
Note:  Items enclosed in brackets are optional.
Database Procedure
Syntax
JDBC/ODBC CALL escape
{[? =] CALL [schema.]name[( parameters )]}
Ingres EXECUTE PROCEDURE
EXECUTE PROCEDURE [schema.]name[( parameters )] [INTO ?]
Ingres CALLPROC
CALLPROC [schema.]name[( parameters )] [INTO ?]
For all of these statements, the JDBC Driver supports a combined parameter syntax supporting features of the ODBC positional parameter syntax and the Ingres named parameter syntax:
parameters := param | param, parameters
param := [name =] [value]
value := ? | literal | SESSION.table_name
literal := numeric_literal | string_literal | hex_string