Gox wrote:
Hi.
This is my situation:
Backend: Oracle 8i
Frontend: MS Access 2k (ODBC driver support LOBs)
Q: How insert (upload) a CLOB (pdf or doc file) to an Oracle using MS
access (form)??
Q: How display (download) a CLOB (pdf or doc file) from Oracle using MS
access (form)??
Any example or hint???
It sounds like you want to store the documents as OLE Embedded Objects
within the Oracle database. If so, then don't use CLOB columns. They
are for storing character data and usually appear in Access linked
tables as "Memo" fields.
Instead, use BLOB columns. They are for storing binary data and appear
in Access linked tables as "OLE Object" fields.