Special Features in SQL Mode ORACLE 

·        The isolation levels 0, 1, 2, 3 are permitted in the SQL mode ORACLE. The default isolation level is 1.

·        You need to define the appropriate sqlda structures for dynamic SQL statements. They are compatible with the ORACLE sqlda structures, but contain additional internal SAP DB information. Use the appropriate INCLUDE files that are included automatically when the precompiler runs.

/*Declaration*/

SQLDA orada;

/*Initialization*/

orada = sqlald (max_vars, max_name, max_ind_name);

where max_vars indicates the number of parameters, max_name the maximum number of characters in the parameter names, and max_ind_name the maximum number of characters in the indicator names.

·        With a few exceptions, the return code sqlcode of the database system is copied from SAP DB (see Messages: SAP DB).

This table shows the exceptions and the corresponding SAP DB message codes:

ORACLE Message Code	SAP DB Message Code
-1008	Warnung3
-1007	-804
-1034	-813
0	-4000
Warnung1	-743
100	1403 ROW NOT FOUND