CODEWITHSUNDEEP
oracle-databaseodp.netsqlbulkcopyora-03113
maephisto
maephisto

Reputation: 333

Oracle ODP.NET BulkCopy to temporary table issue

I'm using BulkCopy method from ODP.NET to insert a DataTable to a temporary table. If the temporary table is simple (no triggers or indexes) it works, fine, but as soon as I create an index or trigger, i get the "End-of-file on communication channel" error at BulkCopy.WriteToServer() method. Any idea how could i fix this?

Thank you!

Upvotes: 1

Views: 1372

Answers (4)

Marius
Marius

Reputation: 193

I've contacted Oracle about this. Apparently it's a bug, that was fixed in 11g. They're now trying to release a patch

Upvotes: 0

Jon Heller
Jon Heller

Reputation: 36807

Temporary tables in Oracle are almost always a bad idea. Can you re-design the program to use either a regular table or a PL/SQL collection?

Upvotes: 0

Christian Shay
Christian Shay

Reputation: 2635

I concur with the posters above. Check your alert log file. If you see an ORA-600 there, you (or your DBA) should contact Oracle support because you may need a patch.

Christian Shay Oracle

Upvotes: 0

Rob van Wijk
Rob van Wijk

Reputation: 17705

In case of an ORA-03113: end-of-file on communication channel, the server process dedicated to your session died because of a bug or error. The client process detects that the server process is missing and raises the ORA-03113. The server process has written its error message to the alert file. Check this file on the server to find out what went wrong. You may have to ask your DBA to do this for you.

Regards,
Rob.

Upvotes: 2

Related Questions