ORA-1405 Error w/ORACLE7 and Pro-C, HELP!
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-6077Received on Wed Oct 06 1993 - 17:24:07 CET