Page 1 of 1

Is OracleLoader supporting triggers ?

Posted: Thu 12 Oct 2006 07:17
by SmartK8
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

Posted: Thu 12 Oct 2006 10:51
by Alexey
Try to use DML Arrays. For more information see our ArrayBind sample.