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

<SPAN

class=254073118-05092001>Jacques,
<SPAN

class=254073118-05092001> 
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"! 
<SPAN

class=254073118-05092001> 
<SPAN

class=254073118-05092001>:)
<SPAN

class=254073118-05092001> 
hope
we're helpful!
 
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Jacques Kilchoer   [mailto:Jacques.Kilchoer_at_quest.com]Sent: Wednesday, September 05,   2001 2:35 PMTo: 'ORACLE-L_at_fatcity.com'Cc:   'NDATFM_at_labor.state.ny.us'; 'hamcdc_at_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 [<A
  href="mailto:NDATFM_at_labor.state.ny.us">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:30:34 CDT