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 -> Re: OCI and NULLS

Re: OCI and NULLS

From: Roberto Vespa <wasp_at_inwind.it>
Date: Wed, 09 Oct 2002 18:41:57 GMT
Message-ID: <VL_o9.26229$Fz.749126@news1.tin.it>


Ok, thanks, I checked the documentation about indicators and I think I found a way, I'll try.
Thanks again :o)

Wasp

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:jub7quop25gtiuug5v643d94jkjmoq2k3g_at_4ax.com...
> On Tue, 08 Oct 2002 21:18:01 GMT, "Roberto Vespa" <wasp_at_inwind.it>
> wrote:
>
> >Hi everybody.
> >I'm completely new to OCI programming, so maybe I'm trying to do
something
> >absurde, but...
> >I'm a C++ developer, trying to build a code layer in order to virtualize
> >data access in my app, so that it can be used with both DB my enterprise
> >supports, ORACLE and SQL Server. I'm using ADO with SQL Server, and I
> >introduced lately OCI with ORACLE. It works great, I improved performance
> >dramatically. Now, my problem: if I do an INSERT INTO binding, for
example,
> >a big array of strings, it works ok until I dont have to store NULLS in
DB,
> >I mean some values are NULLS but not every value in the array. It's not
that
> >it doesnt work, is that I don't know how to manage it. More generally, is
it
> >possible to fill an array that is going to be bound to a statement in a
way
> >that NULLS can be passed and stored by INSERT INTO, what ever the field
type
> >is (VARCHAR, DATE, NUMBER... accepting NULLS, of course)? I hope I've
been
> >clear...
> >Advices or links to useful infos would be veeeery appreciated :o)
> >Thanks,
> >
> >
> >Wasp
> >
>
>
> In Pro*C you need indicator variables for any column that can be NULL.
> Most likely you need them in OCI too.
>
> Hth
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Oct 09 2002 - 13:41:57 CDT

Original text of this message

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