Error in query

From: Pascal Byrne <pbyrne_at_icada.com>
Date: 7 Jan 2002 09:33:52 -0800
Message-ID: <e45d1299.0201070933.41f9eae6@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 - 11:33:52 CST