Re: Using UPDATE with ROWNUM?

Hasta wrote:

> But why would the OP get ora-1555, Joel (and Frank and Daniel) ?
>
> He is not commiting in a cursor loop, afaics
>
> begin
> loop
> update (select seq_no from mytable) set seq_no = tempseq.nextval
> where rownum <= 1000;
> exit when SQL%FOUND = false;
> commit;
> end loop;
> end;
>
> --- Raoul

Lets see:

   EXIT ...
   COMMIT ...
END LOOP ...

He isn't?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org