Inserting an Oracle Blob image into a Crystal Report
Posted on 2002-06-16
I'm having trouble with Crystal Reports 8.5. I am trying to insert a field into my report which maps
to a blob image column in Oracle.
The source inside the report is simply a database table consisting of a VARCHAR2 id field and a BLOB
field. When I drag the id field into the report it works fine. However when I go to drag the Blob field,
the error "No rowset was returned for this table, query, or procedure".
Oracle version 126.96.36.199.0
Crystal version 8.5
Connecting the two using a "Microsoft OLE DB Provider for Oracle" connection.
In a document from Crystal Decisions, it specifies that from version 8 onwards, Crystal can read Long
Raw and Blob fields.
I have heard that there may be an error on the Oracle end which has been fixed in Release 3 of Oracle
8i. I am trying to find out if this is true.