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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why doesn't this cure my ORA-04030?

Re: Why doesn't this cure my ORA-04030?

From: prl <prlawrence_at_lehigh.edu>
Date: Fri, 13 Feb 2004 10:38:35 -0500
Message-ID: <402CEF7B.3080805@lehigh.edu>


Bricklen wrote:

> prl wrote:
>

>> I'm using
>>   FETCH ... BULK COLLECT INTO >>>>> LIMIT 100
>> and then subsequently
>>   FORALL ... INSERT INTO

>
>
> Use the LIMIT keyword

Thank you very very much! That did the trick.

Phil Received on Fri Feb 13 2004 - 09:38:35 CST

Original text of this message

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