Re: BULK BIND question

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 06 Feb 2006 14:34:26 -0800
Message-ID: <1139265260.894899@jetspin.drizzle.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. Use the limit clause and you will be fine no matter how large the source.

With respect to the other question about NOCOPY. There is a specific caveat about what may happen if an exception occurs in the code. Go to http://tahiti.oracle.com, look up NOCOPY, and understanding the warning.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Feb 06 2006 - 16:34:26 CST