Re: ORA-01405: fetched column value is NULL
Date: 9 Feb 1995 18:49:01 GMT
Message-ID: <3hdo2t$hep_at_dcsun4.us.oracle.com>
In article <3hbs5u$mtr_at_newsbf02.news.aol.com>, sharkbones_at_aol.com (Sharkbones) writes:
|> Help!
|> We are migrating a few PRO*COBOL reports (about 200) from ORACLE 6 and
|> OpenVMS VAX to ORACLE 7 and OpenVMS AXP. I compiled and relinked the
|> reports.
|> When I run the reports under ORACLE 7, it seems that the warning
|> "ORA-01405: fetch column value is NULL" is returning a negative SQLCODE
|> and setting the SQLERROR. We have a WHENEVER SQLERROR statement in all
|> the reports that terminates them cleanly whenever there is an SQLERROR.
|> When the reports are run under ORACLE 6, they run fine. I assume the same
|> warning only sets the SQLWARNING, which is ignored. The reports continue
|> processing.
|> This is frustrating. Can anybody offer a solution to this?
|> Thanks in advance,
|> Ron Young
You need to use indicator variables on all your select statements, or use the precompiler option DBMS=V6. Received on Thu Feb 09 1995 - 19:49:01 CET