Re: How to handle ora - 01405 in PRO*C.

Johnny chopra wrote:
>
> Does someone knows how to handle ORA - 01405 IN PRO*C

This is from the ORA.HLP file:

ORA-01405 ORA-01405 fetched column value is NULL

Cause: The INTO clause of a FETCH operation contained a NULL value, and no indicator was used. The column buffer in the program remained unchanged, and the cursor return code was +2. This is an error unless you are running Oracle7 with DBMS=6, emulating version 6, in which case it is only a warning.
Action: You may do any of the following:

·_Use the NVL function to convert the retrieved NULL to another value, such as zero or blank. This is the simplest solution. ·_Use an indicator to record the presence of the NULL. You probably should use this option when you want a specific action to be taken when a NULL arises.
·_Revise the cursor definition so that no columns possibly containing NULL values are retrieved.

Copyright (C) 1995, Oracle Corporation

Yours
Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Tue Feb 02 1999 - 06:15:30 CST