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
>
>
>I have seen the problem under Solaris 2.3 using Oracle 7.0.16. The fix was to
>upgrade to Oracle 7.1.4, which brings it's own set of issues, but you should be
>okay if you use Pro*C version 1.6. Version 2.0 is just to new, like most x.0
>releases.
>
>Good luck.
>Craig
>

You have to use a dbms=v6 option on your proc to get rid of this normally. That having been said there is a logged bug against 1.16 about this when there are over n columns in the select.

Hope this helps

Geoff Coleman Received on Wed Feb 08 1995 - 04:33:47 CET