PRO*C and Oracle 7

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

this is caused by having not having indicator variables on host variables which return NULLs. The ProC manual says theat using DBMS=V7 and MODE=ORACLE will get rid of the problem - it doesnt. The response Centre suggests DBMS=V6 and MODE = ORACLE this gets rid of the problem but doesnt appear to be a long term solution.

When we modified our ProC programs to use indicator variables on every returned column we experienced some VERY unpredictable results. Some programs were OK, some core dumped and others returned esoterical errors such as 'RTL-2109 Inconsistent host cache'. All the affected programs were mature well used programs which had previously behaved correctly.

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

Thanks for any help.

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