This content has been marked as final. Show 2 replies
once i came across same problem i resolved it by starting transactions for each set of 100 rows than another hundered and in the end i commited all transactions and in case of exception i rolled back all. try this may be this would help you though i know it is not proper solution.
Edited by: 928389 on Apr 18, 2012 12:01 AM
As the error message says, the plsql block is simply too large. You can break it up into smaller blocks, or better yet do it a different way as that's really not a very efficient method.
You might want to look into the Array Binding feature of ODP.NET, and here's an example walkthrough by my buddy Mark.