Re: loading data from flat file into oracle table.

From: What's in a namespace <whatsin_at_xs4all.nl>
Date: Fri, 19 Jan 2007 15:18:48 +0100
Message-ID: <45b0d34b$0$322$e4fe514c@news.xs4all.nl>

<v.sorna_at_gmail.com> schreef in bericht
news:1169211516.698151.152330_at_m58g2000cwm.googlegroups.com...
> Hi,
> I'm new to DPL/OCI/OCCI.I'm trying to load data from flat file into
> table.
>
> 1)Connection to db(tested by inserting rows programatically)
>
> 2)Reading a dat file in E:\\test.dat which has tab seperated values
> into double dim array
>
> 3)allocating direct path context handle and setting attributes
>
> 4) allocating direct path column array handle using OCIHandleAlloc
>
> 3)setting the array created as direct path column array (dpca)
> OCIDirPathColArrayEntrySet
>
>
>
> Now that at the point,direct path stream (dpstream) handle is to be
> allocated and used to convert dpca into dpstream, OCIHandleAlloc is
> failing with ORA-24316: illegal handle type .
>
> So from that point everything is failing.
>
> Pleasae help me out ,...
>

Take a look at External Tables! Received on Fri Jan 19 2007 - 08:18:48 CST