|GNADE User's Guide: GNADE, The GNat Ada Database Environment; Version 1.5.3; Document Revision $Revision: 1.45 $|
This section describes the migration steps for migrating from legacy code to GNADE embedded SQL. Because only a limited number of ports have been performed this section will evolve over the time.
The Oracle product seems to have a lot of extension compared to ISO/92. Migrating from Oracle to GNADE using ODBC has to be done manually.
All host variables have to be moved into the DECLARE section and the types of these variables has to be reworked as it is required by ISO/92.
The default SQLCA with the name ORACLE does not exist. Due to the fact, that the contents of the GNADE SQLCA is different this code has to be reworked manually.
The ESQL translator of Oracle supports non ISO/92 WHENEVER clauses which are supported by the GNU ESQL translator as well.
Due to the fact, that ODBC requires different parameters for the CONNECT clause this has to be reworked as well.