Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Strange (I think, anyway) ORA-01722 error.

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

From: <siglerg_at_medimmune.com>
Date: 1997/02/05
Message-ID: <855170066.28551@dejanews.com>#1/1

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
Received on Wed Feb 05 1997 - 00:00:00 CST

Original text of this message

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