ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting DataTable into Oracle table

880362Aug 5 2011 — edited Aug 8 2011

Hi,

I wan to insert all the data in Datatable to Oracle table. Can anyone let me know a best approch for inserting?

currently I am creating parameters as PL/SQL associated array for each column and will running the command.executenonquery()

If I insert data as above then system is taking more resources and I am getting OutOfMemory exception. I am having data around 1,000,000 rows and each row having 20 columns.

Please let me know any other ways of insertion using ODP.NET?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2011

Added on Aug 5 2011

#odp-net

1 comment

989 views