SQL & PL/SQL

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!

How to insert multiple rows in single execution

567889Mar 20 2007 — edited Mar 20 2007

hi,
i am working on .net 2.0 and using DAAB(data access application block) to communicate with oracle 10g.
Currently to insert multiple rows in a table, procedure is getting executed in a loop.can i avoid these many calls to database and insert multiple rows in a single call to database?
i tried with pl/sql associative array approach but it seems that it is not supported by DAAB.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2007

Added on Mar 20 2007

15 comments

1,973 views