From NDATFM@labor.state.ny.us Wed, 05 Sep 2001 11:30:34 -0700 From: "Mercadante, Thomas F" Date: Wed, 05 Sep 2001 11:30:34 -0700 Subject: RE: create sequence in PL/SQL anonymous block - needs to be in se Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: create sequence in PL/SQL anonymous block - needs to be in se Jacques,   sorry if we confused you.  some of us on this list tend to answer questions that were not asked, but we thought "should have been"!    :)   hope we're helpful!   Tom Mercadante Oracle Certified Professional -----Original Message-----From: Jacques Kilchoer [mailto:Jacques.Kilchoer@quest.com]Sent: Wednesday, September 05, 2001 2:35 PMTo: 'ORACLE-L@fatcity.com'Cc: 'NDATFM@labor.state.ny.us'; 'hamcdc@yahoo.co.uk'Subject: 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@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?