Ingres 11.2 | DECLARE Example

SQL Reference Guide > SQL Reference Guide > SQL Statements > DECLARE > DECLARE Example

Was this helpful?

DECLARE Example

The following example demonstrates some declarations and uses of local variables:

CREATE PROCEDURE variables (vmny MONEY NOT NULL) AS
       DECLARE
       vi4    INTEGER NOT NULL;
       vf8    FLOAT;
       vc11   CHAR(11) NOT NULL;
       vdt    DATE;
       BEGIN
       vi4 = 1234;
       vf8 = null;
       vc11 = '26-jun-1957';
       vdt = date(:vc11);
       vc11 = :vmny;--data type conversion error
       vmny = :vf8;--null to non-null conversion
              error
       RETURN :vi4;
END;

Last modified date: 08/28/2024