Inserting HUGEBLOB image into crystal
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22473
Printed Date: 29 Apr 2024 at 9:47am
Topic: Inserting HUGEBLOB image into crystal
Posted By: cbaldwin
Subject: Inserting HUGEBLOB image into crystal
Date Posted: 09 Oct 2017 at 4:05am
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
|
Replies:
Posted By: cbaldwin
Date Posted: 09 Oct 2017 at 4:07am
|
Note that without the "SIGNATURE" field being selected in the command table, my report works correctly.
|
Posted By: kevlray
Date Posted: 09 Oct 2017 at 8:54am
|
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)?
|
Posted By: cbaldwin
Date Posted: 09 Oct 2017 at 9:01am
|
What is TOAD and acronym for?
|
Posted By: kevlray
Date Posted: 10 Oct 2017 at 4:00am
I know it just as
multi-platform database query tool from Quest software.
|
Posted By: cbaldwin
Date Posted: 10 Oct 2017 at 7:29am
Posted By: hilfy
Date Posted: 17 Oct 2017 at 9:07am
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
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|