Subject Re: [ib-support] PROCEDURE_ID of RDB$PROCEDURES
Author Helen Borrie
At 05:18 PM 27/01/2003 +0900, you wrote:
>Hi, All.
>
>I create/delete stored procedure at frequent intervals.
>PROCEDURE_ID of RDB$PROCEDURES is incremented when creating stored
>procedure, but if it delete, the ID will be reused.
>
>When PROCEDURE_ID exceed its limit(== 2^15), I cannot create a new
>stored procedure.
>
>Is there any idea to avoid this situation ?

The counters will be re-set when you perform a gbak and restore.

heLen