Re: ORA-01405: fetched column value is NULL
Date: 1996/08/21
Message-ID: <321B5F4D.1CFB_at_ts.es>#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
This is a very common error. You are fetching into a column value empty.
In a PRO*C the solution is to declare a indicator variable
(See PL/SQL User's Guide and Reference page 8-11)
In a PL/SQL ask for the variable after the fectch.
Good luck and grettings:
Elisa.
Received on Wed Aug 21 1996 - 00:00:00 CEST