I am in the process of migrating an Access 2007 database to an Oracle 10g database and ran into an issue with one of the field conversions.
In Access I have some Attachment fields that hold Microsoft word .docx files. I used SQL Developer to do the migration and it suggested using the Blob datatype in Oracle 10g. Access crashes when trying to retrieve the Blob because it does not know how to see this type. What would some code be for converting the attachment to a blob and converting the blob back into an attachment. I have found nothing online for this. It is key that the Word documents are held in this database.