Re: drop and create sequence!

try DBMS_SQL package

Shahram Shahdadi wrote in message <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 Fri Jul 02 1999 - 10:04:19 CEST