Oracle provides an extra copybook, ORACA, for use with dynamic SQL. This can be included in your program using the following syntax:
EXEC SQL INCLUDE ORACA END-EXEC
You must set the Oracle precompiler option, ORACA=YES before you can use the ORACA copybook. For more information on setting Oracle precompiler options, refer to the Programmer's Guide to the Oracle Precompilers.
Oracle does not supply an SQLDA. For a clearer explanation of this and the ORACA copybook, refer to the Programmer's Guide to the Oracle Precompilers.