Re: Pro*C Indicator Variables (bug?)
From: Carl Gohringer <cgohring_at_lucifer>
Date: Mon, 28 Nov 1994 17:15:30 GMT
Message-ID: <CzzMLu.LqA_at_nl.oracle.com>
Date: Mon, 28 Nov 1994 17:15:30 GMT
Message-ID: <CzzMLu.LqA_at_nl.oracle.com>
dcure_at_ifremer.fr (David Cure) writes:
: >The Pro*C manual says that "When MODE=ORACLE, ORACLE does not
: >issue and error if you SELECT or FETCH a null into a host
: >variable that is not associated with an indicator variable."
: >
: >That would seem to contradict the error message that we
: >are getting (i.e. ORA-01405: fetched column value is NULL").
: >
This is new in PRO*C 1.5 and is not a bug. You must use an indicator variable if fetching NULLs.
Why was this change made?
It was made to become compliant with ANSI SQL standards.
The new behavior is the standard.
-- regards, Carl +-----------------------------------------------------------------------------+ Carl Gohringer, European Development Centre Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG Internet : cgohring_at_uk.oracle.com +-----------------------------------------------------------------------------+Received on Mon Nov 28 1994 - 18:15:30 CET