Strange (I think, anyway) ORA-01722 error.

Having a problem with a simple select from a view. All columns in the view are nullable. My example is:

select a,b,c
from aview
where c is null;

Column 'c' is of datatype number. From selecting a dump(c,16) to get it in hex, I know that column 'c' in plenty of rows is indeed null. So, why does this query return an ORA-01722?

If I remove the where clause, the query runs.

I'm on Solaris 2.5.1 running Oracle 7.1.6.

Please respond with email, too, as I can't live on DejaNews :-(. (siglerg_at_medimmune.com)

Thx,

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet