Re: OCI question: about null string

jocave_at_yahoo.com (Justin Cave) wrote in
news:233b7a65.0211291353.3902e8f_at_posting.google.com:

> My guess is that you're not providing OCI with an indicator variable
> when you bind your char* buffer. This is the only way for OCI to
> tell you that you've fetched a NULL value (it doesn't change the
> data in the buffer you've passed in, so the buffer is likely to have
> garbage in it unless you've initialized it).

Justin is spot-on. Just a little clarification to the Oracle docs:

1. If you do _not_ provide an indicator variable, you will get ORA-01405 on NULL values.
2. If you do provide an indicator variable, you will _not_ get ORA-01405 on NULL values _and_ the indicator value will be set. -- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.com