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 -> COMMIT in for loop

COMMIT in for loop

From: <amyleone_at_my-deja.com>
Date: Fri, 18 Jun 1999 17:49:49 GMT
Message-ID: <7ke0rp$noi$1@nnrp1.deja.com>


I am getting an Oracle internal error when doing a COMMIT inside a FOR loop in my PL/SQL procedure. Are you not allowed to do that? It was working before, in fact it works for about 200000 rows before it crashes. Thanks for any help you can give.

Amy

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 18 1999 - 12:49:49 CDT

Original text of this message

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