Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: BULK BIND question
artmt_at_hotmail.com wrote:
>
> Thanks.
> I have read this thread before.
>
> Let me re-phrase the question:
> Is there any harm in BULK BINDing just a handfull of rows?
>
> Thanks
> -Art
No. As long as your PL/SQL table is within reasonable size limits, bulk bind should be a positive experience for you.
You may also want to check out the "bulk exceptions" options to handle what happens if (say) 2 of your (say) 10 bulk binded rows fail insert
hth
-- Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" Co-author: "Oracle Insight - Tales of the OakTable" web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald_at_yahoo.com "Semper in excremento, sole profundum qui variat." ------------------------------------------------------------Received on Sat Feb 04 2006 - 20:52:24 CST