On Tue, Aug 31, 2004 at 11:35:38AM -0700, Ron St-Pierre wrote: > We're doing it in multiple transactions within the function. Could we do > something like this?: > > .... > BEGIN > FOR rec IN SELECT field01, field02, ... FROM otherTable LOOP > RETURN NEXT rec; > UPDATE dataTable SET field01=rec.field01, field02=rec.field02, > rec.field03=field03, ... > WHERE id = rec.id; > COMMIT; > .... > > > If we can do it this way, are there any other gotcha's we should be > aware of?
AFAIK you should be able to do this, yes (although I have no experience with PL/SQL); I'm not sure how much it buys you, but you might want to test it, at least. /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly