Re: SQLT_CHR and null-values in OCI

From: Amit <jindal_at_roguewave.com>
Date: Thu, 28 Aug 2003 16:42:01 -0600
Message-ID: <bim3qa$a08$1@tux.cvo.roguewave.com>

Try using SQLT_AFC.

---

Amit Jindal, Development Engineer

Want ease of development or performance? Why not get both! http://www.roguewave.com/products/sourcepro/db/

[Disclaimer: All views expressed here are my personal views

             and they can be incorrect at times]

---

"Tommi Mäkitalo" <t.maekitalo_at_epgmbh.de> wrote in message news:u8jkib.u22.ln_at_192.168.31.31...
> Hi,
>
> after further investigation I found out, that even a indicator-variable
does
> not help. It looks like it is not possible to insert spaces into a column
> using SQLT_CHR. My inputdata is not zeroterminated and it would be nice to
> tell oracle to just fetch the fixed-size data as is.
>
> Tommi Mäkitalo
>
>
>
> Tommi Mäkitalo wrote:
>
> > Hi,
> >
> > I bind a field of type 'varchar2(001) not null' with SQLT_CHR. I thought
I
> > don't need indicator-variables, because I don't want to (and can't)
insert
> > null-values into the field. But when I try to insert spaces, I get
> > "ORA-01400: cannot insert NULL into (...)".
> >
> > Is there a way to get around a dummy indicator-variable, which
indicates,
> > that the column is not null?
> >
>
> --
> Tommi Mäkitalo
> Dr. Eckhardt + Partner GmbH
Received on Thu Aug 28 2003 - 17:42:01 CDT