[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



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