Re: loading data from flat file into oracle table.

On Jan 19, 9:18 am, "What's in a namespace" <what..._at_xs4all.nl> wrote:
> <v.so..._at_gmail.com> schreef in berichtnews: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!- Hide quoted text -- Show quoted text -

If the job is to be triggered from outside the database then why not just use sqlldr utility? If you want to trigger the task from within the database then use the mentioned External table feature (which is an interface to sqlldr).

For OCI coding check the manuals and see if you can find an example to compare to.

HTH -- Mark D Powell -- Received on Fri Jan 19 2007 - 09:24:51 CST