ORA-1405 Error w/ORACLE7 and Pro-C, HELP!

From: Henry B Smith <henrys_at_feenix.metronet.com>
Date: Wed, 6 Oct 1993 16:24:07 GMT
Message-ID: <CEHHK8.GHG_at_feenix.metronet.com>


I am running Oracle 7 and Pro-C Version 1.5 on an IBM RS6000 with AIX.

At the top of page 4-5 in the *Programmers's guide to the ORACLE Precompilers Version 1.5* it states:   

    When MODE={ANSI13 | ORACLE}, you can SELECT or FETCH nulls into a     host variable not associated with an indicator variable...

.
.
.

    However, when MODE={ANSI | ANSI14}, if you SELECT or FETCH nulls into a     host variable not associated with an indicator variable, ORACLE issues

       *ORA-01405: fetched column value is NULL.

I have set MODE=ORACLE in the compile line and I still get ORA-01405. The only way that I can *NOT* get the error is if I use an indicator variable (contrary to the documentation) or use the NVL option.

Any ideas?

-- 
Henry B. Smith - NA5K           |  henrys_at_feenix.metronet.com
1380 Camino Real                |  Home phone   (214) 562-3049
McKinney, TX 75069              |  Office phone (214) 333-6077
Received on Wed Oct 06 1993 - 17:24:07 CET

Original text of this message