Using Executable Procedures in isql
From InterBase
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
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