Is OracleLoader supporting triggers ?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
SmartK8
Posts: 8
Joined: Thu 13 Jul 2006 09:15
Contact:

Is OracleLoader supporting triggers ?

Post by SmartK8 » Thu 12 Oct 2006 07:17

Hi, we're building a framework for a huge russian corporation and we've successfully (by your advice) downgraded their servers (~4 months to do so btw) to the Oracle 9i so the OracleLoader is working now. But we're experiencing a different issue. They've triggers to be triggered along the OracleLoader processing (any Bulk-insert process to be precise). So we're thinking about supporting two modes:

1) a fast mode without support for the triggers (standard OracleLoader)
2) a slower mode with support for the triggers

So my question is:

Is there a way to run any component of yours in a mode that supports the triggers ?

regards,
Kate

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 12 Oct 2006 10:51

Try to use DML Arrays. For more information see our ArrayBind sample.

Post Reply