Re: ODBC Null Values ...

From: <formula_fo_at_my-dejanews.com>
Date: Thu, 29 Oct 1998 14:21:48 GMT
Message-ID: <719tlr$9t$1@nnrp1.dejanews.com>

Maybe related to a problem we've just discovered:

If VARCHAR2 variable "text" contains only spaces, PL/SQL statement RTRIM(text) should return NULL. In ORACLE 7.3.3 we get rubbish, i.e. "IF RTRIM(text) IS NULL " will return FALSE. According to ORACLE Support Norway this is bug #414449. They say that there exist no fix for it and suggest that we work around it by concatenating an empty string to the RTRIM expression.
Problem is solved in ORACLE 8.0.5.
Bug occurred first time in ORACLE 7.3.3.

Erik

In article <363719D4.32F8519F_at_india.hp.com>, "Sandeep.Konchady" <sky_at_india.hp.com> wrote:
> Hi,
>
> I am using Oracle 7.3.3 and ODBC SDK 3.5. I use Oracle's ODBC driver
> version 2.03. When my query returns a null value, after SQLBindCol, I
> get junk values. I do not know why it is not returning the NULL value
> as such. Can anyone explain please ?
>
> Thanks,
>
> Raghu

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 29 1998 - 08:21:48 CST