Title: RE: create sequence in PL/SQL anonymous block - needs to be in se

Thank you for the suggestions Thomas and Connor. This was only an example pulled from a much larger procedure that doesn't have a for loop. My main question was about the "missing sequence" error.

> -----Original Message-----
> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
>
> like Connor said, why use a sequence?  you have a perfectly
> good sequence
> number in the loop index.
> why waste the time of creating and dropping a sequence?

Reply via email to