CODEWITHSUNDEEP
c#oracle-databaseado.net
Yaron Ohana
Yaron Ohana

Reputation: 178

Is there a way to use OracleBulkCopy with oracle database sequence?

I want to use bulk insert to a table with sq. Is there a way to use OracleBulkCopy with oracle database sequence?

Thanks

Upvotes: 1

Views: 914

Answers (1)

TomTom
TomTom

Reputation: 62093

Yes. Do not insert into a table with a sequence.

Intead insert into a temporary table and then use appropriate sql to copy to the final destination table.

I have siomilar approaches on SQL Server - bulk copy into temporar table, then to server side processing to final destinations.

Upvotes: 1

Related Questions