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 -> Re: ORA-00932: inconsistent datatypes /long raw field

Re: ORA-00932: inconsistent datatypes /long raw field

From: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Sun, 21 Mar 1999 17:14:14 GMT
Message-ID: <36f62176.27237575@news.demon.co.uk>


On 5 Mar 1999 16:51:55 GMT, Andreas Jung <ajung_at_sz-sb.de> wrote:

>
>Under Oracle 7.3.3/Solaris 2.5.1 we have the following problem:
>
>create table sux(sux long raw);
>select * from sux;
>
>ERROR:
>ORA-00932: inconsistent datatypes
>
>What's the problem behind here ?
>
>Thanks,
>Andreas

SQL*Plus (and most other ad-hoc interfaces) forces an "implicit" conversion to character on all output columns, but there is no such thing from LONG RAW, hence the message.

Regards,

Eric Received on Sun Mar 21 1999 - 11:14:14 CST

Original text of this message

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