I am attempting unsuccessfully to insert an image of a signature into my crystal report. The image is listed as the {signature} field in the DQNR table. Note that dreamcoder notes that thE {signature} field contains a (HUGEBLOB).

I can successfully get the SIGNATURE field to display in crystal Field Explorer as SIGNATURE:Picture. I can successfully add the field to my crystal report.

Note that this is from an oracle database.

Note that my DQNR table is a crystal Command table.

When i run the report i get the following errors:

-Failed to retrieve data from the database

-Database Connector Error:'ORA-22992:cannot use LOB locators selected from remote tables'

-Database Connector Error: 'Fail to fetch data. OCI Call:OCIStmtFetch'

Anyone with thoughts?
cjb

Well you are getting a database error.  Have you taken the command sql and see if it will run in a database tool (like TOAD)?

I know it just as  multi-platform database query tool from Quest software.

What version of Crystal and what version of Oracle?

What is the format of the image? It needs to be in an image format - .jpg is preferred. Also, you need to be using the Oracle Native Client for the database connection and not ODBC.

For your command, what happens if you cast the HUGEBLOB field as BLOB?

-Dell