Reading BLOB fields from ORACLE

  • Thread starter Thread starter dawn syverson
  • Start date Start date
D

dawn syverson

I have an access application that links in a table that is
in Oracle 9i. One of the fields in the table is a blob
datatype and stores pictures. When I pull this field into
a form the form just displays a grey box with no image in
it. Can blob fields be read by access? I can't seem to
find any documentation on it on the web or in the help
files. Any assistance you could provide would be greatly
appreciated. TX
 
Access doesn't have a way of natively displaying raw-binary/blob images (other than OLE Embedding which
is generally not a good approach with images, particularly with compressed formats like jpeg).

It is possible to write code to extract to temporary files, then display these in an image control, however
there are caveats with this approach, plus the performance and complexity are non-optimal. There are also
commercial 3rd-party alternatives. Our image control, for example, binds directly to binary data in Access,
so it is trivial to use, and features asynchronous (background) decoding, EXIF viewer, lossless JPEG rotation
and more.
 
Back
Top