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

Reply via email to