Re: ORA-01405: fetched column value is NULL
Date: 1996/08/20
Message-ID: <321A9146.6AB5_at_nb.net>#1/1
Benjamin Taub wrote:
>
> Does anyone out there have experience with this error message? We are fetching values
> into variables and we know that some of the columns will contain nulls. It appears that
> these nulls are causing our programs to crash with this error:
>
> ORA-01405: fetched column value is NULL
>
> Is there a quick and easy way to stop this from happening?
> _______________________________________________
> Benjamin Taub btaub_at_dspace.com
> DATASPACE INCORPORATED http://www.dspace.com
> ph: (313) 761-5962 fax: (313) 761-5967
> THE DATA WAREHOUSE INTEGRATORS
I'm not sure what system overhead the NVL function is usually helpful.
For example, NVL(test_number, 0) will set the column to 0 if test_number
is null.
Mike
Received on Tue Aug 20 1996 - 00:00:00 CEST