Is OracleLoader supporting triggers ?

Is OracleLoader supporting triggers ?

Postby 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
SmartK8
 
Posts: 8
Joined: Thu 13 Jul 2006 09:15

Postby Alexey » Thu 12 Oct 2006 10:51

Try to use DML Arrays. For more information see our ArrayBind sample.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle