BULK INSERT ADO.NET & ORACLE

[Guest]

Hi,

I want to do a bulk insert of around 25k records into oracle databse .

can anyone help me out with some work arounds, I have used the bulk insert
in SQL SERVER , but in ORACLE I am unable to do.

your expert advice and support would be highly appreciated.

Rgds
Shiju

 

[Paul Clement]

¤ Hi,
¤
¤ I want to do a bulk insert of around 25k records into oracle databse .
¤
¤ can anyone help me out with some work arounds, I have used the bulk insert
¤ in SQL SERVER , but in ORACLE I am unable to do.
¤
¤ your expert advice and support would be highly appreciated.

See if the following helps:

http://www.ddbcinc.com/askDDBC/topic.asp?TOPIC_ID=116


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Guest]

Thanks for the reply, But I am interesetd in sending the records as xml to
the database, like the openxml feature used in bulk insert for the sql server.

so is there any way to do the same in oracle.

Rgds
Shiju