Re: PRO*C and Oracle 7

> In article <D3M4qF.AqE_at_cuug.ab.ca>, <eveleigc_at_cuug.ab.ca> wrote:
> >
> >
> >> As part of our testing prior to converting from version 6 to Oracle*7,
> >> ProC started to fail with error:
> >>
> >> ORA-1405: fetched column value is NULL
 

> >> Has anybody else experienced this? and even better has anyone found a fix
> >> for it?
 

> >> Steve Taylor S.Taylor_at_lmu.ac.uk
> >> Computer Manager Leeds Metropolitan University
> >
>

This is a documented change of behaviour, for ANSI compatibility I think. There are two solutions.

1 Use dbms=v6 when precompiling. This reverts to version 6 behaviour but is   nnot a viable long term solution

2 Add indicator variable to all select statements

-- 
Jim Smith