Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: possible to 'reset' a sequence by a stored procedure?

Re: possible to 'reset' a sequence by a stored procedure?

From: Norman Dunbar <norman.dunbar_at_lfs.co.uk>
Date: 22 Dec 2003 00:35:37 -0800
Message-ID: <3078e2fe.0312220035.377faf8@posting.google.com>


Stefan Röhle <roehle_at_uni-mainz.de> wrote in message news:<brur5i$c7h$1_at_bambi.zdv.Uni-Mainz.DE>...
> Hi,
>
> I need to 'reset' a stored procedure each time the year changes (2003->2004).
> So what I usually do is a manual
>

Check this out. Dropping a sequence will invalidate any other objects that depend upon it. You can then build some or all of the following into your PL/SQL procedure.

http://www.jlcomp.demon.co.uk/faq/resetseq.html

Cheers,
Norm. Received on Mon Dec 22 2003 - 02:35:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US