ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Populating array bound output parameter is slow (2nd attempt)

IMKDec 6 2013 — edited Jun 17 2014

I have exactly the same issue as described in this archived thread: https://forums.oracle.com/thread/1096352.

Can anyone tell why adding an OUT parameter with array binding has such an adverse effect on performance? We are using Oracle.DataAccess v4.112.3.0.

If I am to call the exact same stored procedure using OracleDataAdapter.Update(DataSet), it comes back 10x quicker than using array binding. And if I'm to remove OUT parameter, then array binding method is at least 5x quicker than OracleDataAdapter.Update(DataSet) in our case.

This post has been answered by IMK on Jun 17 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 15 2014

Added on Dec 6 2013

#11g, #odp-net

2 comments

1,561 views