DECLARE VARIABLE
From InterBase
Go Up to Procedures and Triggers
Declares a local variable. Available in triggers and stored procedures.
DECLARE VARIABLE var data_type;
| Argument | Description |
|---|---|
|
<var> |
Name of the local variable, unique within the trigger or procedure |
|
<data_type> |
Data type of the local variable; can be any InterBase data type except arrays. |
Description: Local variables are declared and used within a stored procedure. They have no effect outside the procedure.
Local variables must be declared at the beginning of a procedure body before they can be used. Each local variable requires a separate DECLARE VARIABLE statement, followed by a semicolon (;).
Example: The following header declares the local variable, ANY_SALES:
CREATE PROCEDURE DELETE_EMPLOYEE (EMP_NUM INTEGER)
AS
DECLARE VARIABLE ANY_SALES INTEGER;
BEGIN
. . .