Using Executable Procedures in isql

Go Up to Using Stored Procedures

An executable procedure is invoked with EXECUTE PROCEDURE. It can return at most one row. To execute a stored procedure in isql, use the following syntax:

EXECUTE PROCEDURE name [(] [param [, param …]] [)];

The procedure <name> must be specified, and each <param> is an input parameter value (a constant). All input parameters required by the procedure must be ­supplied.

Important: In isql, do not supply output parameters or use RETURNING_VALUES in the EXECUTE PROCEDURE statement, even if the procedure returns values. isql automatically displays output parameters.

To execute the procedure, DEPT_BUDGET, from isql, use:

EXECUTE PROCEDURE DEPT_BUDGET 110;

isql displays this output:

TOT
====================
1700000.00