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:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 2:35 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: create sequence in PL/SQL anonymous block - needs to be in seThank 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?
