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