Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQLT_CHR and null-values in OCI

SQLT_CHR and null-values in OCI

From: Tommi Mäkitalo <t.maekitalo_at_epgmbh.de>
Date: Thu, 28 Aug 2003 10:46:19 +0200
Message-ID: <sgfkib.3s.ln@192.168.31.31>


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 - 03:46:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US