Syntax Element           In Ada
prefix                   EXEC SQL
terminator               ;
target                   label_name

Variable Definition Syntax

Ada variable definition =
    Ada variable name.,.. : Ada type spec
    [ = character representation...]

Ada type spec is given below.
The = character representation... sequence
  is an optional initial value.

The Ada variable definition is specified within the scope
of Ada WITH and USE clauses that specify the following:

with SQL_STANDARD;
use SQL_STANDARD;
use SQL_STANDARD.CHARACTER_SET;

This will import the following built-in SQL type definitions:

SQL_STANDARD.BIT (1..length)
SQL_STANDARD.CHAR [CHARACTER SET [IS]
  character set name] (1..length)
SQL_STANDARD.DOUBLE_PRECISION
SQL_STANDARD.INT
SQL_STANDARD.REAL
SQL_STANDARD.SMALLINT
SQL_STANDARD.SQLCODE_TYPE
SQL_STANDARD.SQLSTATE_TYPE

SQL Type                Ada Type
BIT(length)             BIT (1..length)
CHAR(length)            CHAR (1..length)
DOUBLE PRECISION        DOUBLE_PRECISION
INT                     INT
REAL                    REAL
SMALLINT                SMALLINT
SQLCODE                 SQLCODE_TYPE or INTEGER
SQLSTATE                SQLSTATE_TYPE or CHAR(5)
indicator               INDICATOR_TYPE