loading data from flat file into oracle table.

From: <v.sorna_at_gmail.com>
Date: 19 Jan 2007 04:58:36 -0800
Message-ID: <1169211516.698151.152330@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 ,... Received on Fri Jan 19 2007 - 06:58:36 CST