Re: SQLT_CHR and null-values in OCI

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