| SQL adaptation guide for Oracle Database 11, 12 / Data dictionary | |
Informix® uses the TEXT and BYTE data types to store very large texts or images. ORACLE 8 provides CLOB, BLOB, and BFILE data types. Columns of these types store a kind of pointer ( lob locator ). This technique allows you to use more than one CLOB / BLOB / BFILE column per a table.
The ORACLE database interface can convert BDL TEXT data to CLOB and BYTE data to BLOB.
Genero TEXT/BYTE program variables have a limit of 2 gigabytes, make sure that the large object data does not exceed this limit.
ORACLE BFILEs are not supported.