Mark D Powell schrieb:
>
> 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).
I second that.
Unless you need to do other things in the same transaction (or session),
and staging tables are out of the question, sqlldr is IMHO the better choice.
It helpfully takes care of the constraint disabling/enabling and is probably
as fast as direct loads are going to get anyway.
Lots of Greetings!
Volker
--
For email replies, please substitute the obvious.
Received on Fri Jan 19 2007 - 12:02:55 CST
