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: Error in query

Re: Error in query

From: santysharma <santysharma_at_hotmail.com>
Date: Mon, 7 Jan 2002 13:23:19 -0800
Message-ID: <a1d3tt$okcik$1@ID-84096.news.dfncis.de>


what is the datatype of column result ?
santysharma
"Pascal Byrne" <pbyrne_at_icada.com> wrote in message news:e45d1299.0201070933.41f9eae6_at_posting.google.com...
> I have a table with a column called 'result'. I get an error when I do
> a query on the column. e.g.
>
> SQL> select avg(length(result)) from inspection;
> select avg(length(result)) from inspection
> *
> ERROR at line 1:
> ORA-00932: inconsistent datatypes
>
> I have searched the documentation and there doesn't seem to be any
> PL/SQL function called result. I'm curious to know why this is
> happening.
>
> Thanks,
> pascal
Received on Mon Jan 07 2002 - 15:23:19 CST

Original text of this message

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