Programmatic API

Multiple Results

call can collect a result set returned by a stored procedure through a WITH RETURN TO CLIENT cursor. multipleExecute cannot collect results from semicolon-separated SELECT statements in one call; execute independent queries separately.

Stored Procedures and Functions

Scalar IN / OUT / INOUT procedure parameters, scalar function queries, and table function queries are supported. JDBC REF_CURSOR OUT parameter mapping is not supported; receive records from the result set returned directly by the procedure instead.

See Stored Procedure Calls for parameter configuration and examples.