Chapter 14. Embedded SQL Syntax Specification

Table of Contents
The GNU Ada 95 Embedded SQL
Embedded SQL statement
SQL Query and FETCH clause
Embedded SQL declare section
Embedded Exception Declaration
Handling of return codes
SQL Communication Area
Connection Handling
Cursor Handling
Mixing ODBC and embedded SQLcode
Dynamic SQL
GNADE Specific Datatypes

The GNU Ada 95 Embedded SQL

The ESQL translator is based on the ISO/92 standard for Embedded SQL, but a lot of issues have been left out there. In order to allow comfortable coding several extensions have been added, which have been derived from other popular ESQL dialects for Ada 95. These add ons are not specially marked, because i believe without these extensions it would not possible to implement an application.