Please let me know what should be the buffer size upper limit in case of bulk insert. I am using SQL Server 2005.
I have tried different buffer sizes (100, 10000, 20000), for all these, otl is working fine but it crashes for the buffer size greater than 40000. What could be the problem ?
You may want to ask Microsoft Support why that is. There is an OTL code example that shows the limit: http://otl.sourceforge.net/otl4_ex310.htm
Are you calling a stored procedure which contains FORALL? Can show how you're passing your data into the PL/SQL from OTL?
Log in to post a comment.