Re: Pro*C Indicator Variables (bug?)

In article md3_at_epicycle.lm.com, Keith A. Overstreet <kao_at_etgroup.com> writes:
>We're moving from 1.3 to 1.5 of Pro*C.
>
>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").
>
>MODE= ORACLE is the default. We've even explicitly set it.
>
>This only occurs if you have used an indicator variable on
>one of the variables in the select. It seems that if you
>use no indicator variables, it works fine. But if you
>use one, you have to do them all.
>
>Should this work this way?

	On Oracle 7.0.15 (Solaris 2.3), we must always use indicator variable... ???
	(with MODE=ORACLE too).

	David.

---

   _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
   David Cure - Ifremer/Brest - SISMER - BP70 - 29280 PLOUZANE - FRANCE
     Email : David.Cure_at_ifremer.fr / Tel : 98.22.46.42 - 98.22.42.10

   " Apres avoir vu la lumiere, on ne retourne pas dans les tenebres "