Re: what value to use in NVL for columns that may contain a NULL

From: Xavier Neys <xavier.neys_at_12move.nl>
Date: Thu, 13 Sep 2001 21:51:10 +0200
Message-ID: <9nr2ui$2kc$1@news1.xs4all.nl>

Check your Pro*C for indicators.
They are flags "attached" to the variables you select into and are used by Pro*C to let you know when a column is NULL.

HTH,

--
Today, Tomorrow, Together
The DOC
(The Dutch Oracle Company)

Xavier


"NeelSing" <bytetwo_at_hotmail.com> wrote in message news:d3852a1b.0109131031.66eb3eef_at_posting.google.com...


> In Pro*C,

> EXEC SQL DECLARE myCursor CURSOR FOR

>  SELECT NVL( db_field, ??),

>

>             ...

>             ...

> so that I may detect the value read as an empty string

>

> strcmp(var_db_field_read_in, "") == 0

> ...

> Please suggest.

>

> Cheers!

Received on Thu Sep 13 2001 - 14:51:10 CDT