By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,190 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,190 IT Pros & Developers. It's quick & easy.

Oracle CLOB

P: n/a
Gox
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???
Thx!!
Nov 16 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a

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.

Nov 16 '06 #2

P: n/a
Gox
Gord wrote:
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.
Ok, I'll use BLOB column.
Do you have any example (VBA code) for inserting BLOB into Access linked
table??
Nov 16 '06 #3

P: n/a

Gox wrote:
Gord wrote:
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.
Ok, I'll use BLOB column.
Do you have any example (VBA code) for inserting BLOB into Access linked
table??
Sorry, no. Try Google.

Nov 16 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.