Re: Assigning NULL value in PRO*C

Hi,

Look in the precompiler manual for indicater variables. What they basically do is fetch another value from Oracle with which you can determine null values. From the top of my head:

select comm:id from emp

if id = -1 then comm is null otherwise comm is not null.

Regards, Gerrit-Jan Linker
Developer of OraCodes, OraSQL, Oraxcel and OraWeb http://members.aol.com/gjlinker

jack_at_idsintl.com wrote in message <7d95i9$n3d$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I am working on porting an application from Informix to Oracle. The code is
>written in embeded SQL (ESQL). In the Informix code risnull() rsetnull()
are
>used to initialize a C structure with NULL values and to check for NULL
>values. Are there any similar function calls in PRO*C? I know you can use
>indicators to achieve this, but that implies major changes to the code I'm
>working with. Any ideas?
>
>later,
>jack
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 25 1999 - 11:48:35 CST