Re: Select problem

blue wrote:

> We have a customer using our software with an Oracle 9.2.0.4 database.
> Select statements do not return any records where at least one column has a
> NULL value. We're talking about basic selects to such as SELECT * FROM
> batch_schedule WHERE status = 'A'. If I populate all the columns in that
> record with at least empty string, then the record is returned. The
> customer also informed me that he's had this trouble with other software
> running against his Oracle DB as well, but didn't know why.
>
> Running the same code in our test environment here with an Oracle 9.2.0.1
> database, all works as planned.
>
> Is there some kind of Oracle setting for this?
>
> Thanks for your help.
> Frank

You are not working with Oracle if you can enter an empty string and get a behaviour different from NULL. Please post the appropriate DDL and DML so that we can see what it is you are doing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)