[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Selecting EMPLOYEE_PHOTO column of type LONG RAW using SQR
- Subject: Selecting EMPLOYEE_PHOTO column of type LONG RAW using SQR
- From: Daniel Archibald <archibal@USQ.EDU.AU>
- Date: Thu, 5 Apr 2001 13:22:32 +1000
Hi,
I was just wondering if anyone has ever tried selecting a LONG RAW column
from an Oracle database using SQR.
The field EMPLOYEE_PHOTO is storing a BMP-File image, the image is displayed
on a PeopleSoft panel. When executing the SQL against the database to
select this column the following error is displayed:
ORA-00932: inconsistent datatypes
What I am trying to do is select the image from the database in the SQR and
then print it on a report. Any assistance on overcoming this problem would
be greatly appreciated.
Thanks in advance.
Regards,
Dan Archibald.
Environment:
Oracle 8.0.5.0.0
SQR V4.3.4
PeopleSoft 7.6