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:NDATFM_at_labor.state.ny.us]
>
> 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?
Received on Wed Sep 05 2001 - 13:40:24 CDT