Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BULK BIND question

Re: BULK BIND question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 05 Feb 2006 10:52:24 +0800
Message-ID: <43E56868.20C7@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US