drop and create sequence!
Date: Thu, 1 Jul 1999 22:03:35 +0200
Message-ID: <377c0230.0_at_news.ka.choin.net>
Hallo
is it true that entries like "drop sequence blahblah" and " create sequence
blahblah" can't be used in stored procedures and functions?
My problem is that I have to insert and then delete large numbers of
records quite frequently. I have to enumerate the records to be able to
deliver criteria for deleting them from the table. The procedure for this
purpose reads the number of lines in the table, updates the table by
applying the previously defined sequence and then delete them.
The next time I want to delete the records, I have to first drop the
sequence and create it again and then run the stored procedure. I would like
to know if there is a way of automating the deletion and creation of the
sequence so it works as one unit with the procedure?
thx
Received on Thu Jul 01 1999 - 22:03:35 CEST