Re: Error in query

"santysharma" <santysharma_at_hotmail.com> wrote in message news:a1d3tt$okcik$1_at_ID-84096.news.dfncis.de...
> what is the datatype of column result ?

It's not a BLOB or similar by any chance? That will give you the error. Other than that it should work OK.

Ray

> 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 - 16:45:17 CST