Greetings,
We are calling a stored procedure in SSIS using an Execute SQL task
BEGIN ORACLE_DEV.pk_work_unplanned.pr_get_configvalue; END;
We've tried it using {CALL and BEGIN END; and in both cases the procedure (which updates a table in Oracle) takes 10 minutes in TOAD and an hour in SSIS. We don't pass parameters to or from the stored procedure, nor do we return a result set.
This is doing my head in, I can't understand why a stored procedure call should carry such a significant overhead when using an Execute SQL task.
Does anyone have any ideas on how we could optimise this?
Regards,
Tom Webb