Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> BLOB and LONG RAW error in Oracle 8.0.5 from 8.0.4

BLOB and LONG RAW error in Oracle 8.0.5 from 8.0.4

From: Adriano Camargo Rodrigues da Cunha <adrcunha_at_dcc.unicamp.br>
Date: Tue, 20 Apr 1999 20:15:35 -0300
Message-ID: <371D0A97.8C77B346@dcc.unicamp.br>

        Hi, folks.

        I was running Oracle 8.0.4 and had a table using LONG RAW for storing a picture. Everything worked fine. After migrating to Oracle 8.0.5, when I create the table in SQL Worksheet, it creates ok, but any SELECT in it gives the message "Error ORA-0932: inconsistent datatypes". When I use SQL*Plus, no error is reported. When using the table with my Delphi Application, I got the same ORA-0932 error. Again, everything works fine with Oracle 8.0.4. I tried changing the LONG RAW type to a BLOB, without success (same error). The HELP examples of BLOB columns also gives the same error.

	Does someone knows what I'm doing wrong?
	Thanks for your attention,

				Adriano Cunha
Received on Tue Apr 20 1999 - 18:15:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US