The following limits exist for the Oracle 7.3 file system:
Maximum number of fields per key: 16
Maximum number of columns: 254
Maximum length of a char field: 255 bytes
With the Acu4GL product, a maximum of 100 database tables can be open at one time by a single process; see the description of configuration variable MAX_CURSORS in section C.4, "Acu4GL for Oracle Configuration File Variables" in this appendix.
Acu4GL for Oracle supports the following data types.
| COBOL to | Oracle |
| PIC X | CHAR |
| PIC X(n) | CHAR(n) |
| PIC X(n) | VARCHAR2 * |
| PIC X(n) | RAW(n) ** |
| PIC 9(n) | NUMBER(n) |
| PIC 9(n) | RAW(n) ** |
| PIC 9(n)V9(m) | NUMBER(n+m, m) |
| example: PIC999V99 | NUMBER(5,2) |
| Oracle to | COBOL |
| CHAR | PIC X |
| CHAR(n) | PIC X(n) |
| VARCHAR2 | PIC X(n) * |
| DATE | PIC 9(6) or PIC 9(8) |
| NUMBER(n) | PIC 9(n) |
| NUMBER(n, m) | PIC 9(n-m)V9(m) |
| RAW(n) | PIC X(n) ** or PIC 9(n) ** |
| example: NUMBER(4,3) | PIC9V999 |
** indicates that the BINARY directive is required.
Internally, Acu4GL for Oracle makes use of VARCHAR to prevent key fields that are all spaces from being converted to null.
These Oracle data types are not currently supported:
LONG
LONG RAW
Other limits described in Appendix B of the ACUCOBOL-GT compiler Reference Manual apply.