Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error in query
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
![]() |
![]() |