How do I allow Microsoft Access 2007 to read a CLOB in an Oracle linked table?
I am migrating an Access 2007 database to an Oracle 10g database as the backend. I am having issues converting an Access memo datatype to the Oracle equivalent, which to my belief would be a CLOB. The access memo data contains data over 4000 characters so a VARCAHR2 will not work in this instance. Access gives an error when trying to read the converted CLOBS.
How can I allow Access to read the data in the Oracle database.