Hello,

I am a newbie trying to create an API written in C# that connects to
an oracle database and reads/inserts records. right now, i've got it
inserting records one at a time, but i need to be able to insert maybe
5-6 thousand records at one time. The data is not currently in a
database, it is in an array i have in the C# code. I have done some
reading on the subject, and have narrowed down my options -- i can:

1. Bulk Bind
2. Array Bind
3. Insert DataSet

I'm shady on all three of these topics, but if someone could point me
in the right direction; which would be the fastest, most efficient,
that would be great. thanks

"goldenorb82" <goldenorb82 (AT) gmail (DOT) com> wrote

Use Oracle's OCI api and do an array insert using bind variables.
Jim

Hi,

An easy way to do your load is:
1. create an Oracle directory
2. Create an external table that matches your external datafile
organisation
3. load from the exernal table (as you would from a "local" table)

There is an excellent example in the documentation (SQL and PL/SQL
syntax, search for "create table" and then ctrl-F "external": your
whole solution is there)
Have fun.
Ph.


goldenorb82 (AT) gmail (DOT) com (goldenorb82) wrote in message news:<231354a1.0407301230.d74f242 (AT) posting (DOT) google.com>...