OCI question: about null string

From: music4 <cli4_at_lucent.com>
Date: Thu, 28 Nov 2002 11:47:47 +0800
Message-ID: <as43ld$a7d@netnews.proxy.lucent.com>

Dear all,

This is a question about OCI.

I have a field of VARCHAR typed, and it can be null or empty string. I write a OCI function using C language to select this field value. If the field is null, or empty string, I always get a error "ORA-01405: fetched colum value is NULL". So I have to use something like "NVL(the_field, '-9')" to get an alternate string. But here is it possible to let OCI just put a empty string in buffer (char [] typed). I tried "NVL(the_field, '')", it didn't work.

Thanks in advance.
Evan Received on Wed Nov 27 2002 - 21:47:47 CST