Hi,

Anyone have a quick and easy (generic) way of altering all existing stored procedures with existing set of parameters, but setting the body to empty (As suggested below) in order to remove all dependencies on indices.

NB. I am using Delphi 6 and IBX.

Thanks
Maya


Maya McLeod wrote:

> Hi,

> I have a routine to update my Firebird databases, which drops all
> stored procedures, then modifies the table structure and indices as
> necessary, and then runs a script to create all the stored procedures
> again.
>
> Since I have added a recursive stored procedure, the indices (only
> those used by the recursive stored procedure) cannot be dropped (or
> modified) as the server thinks that they are still in use.
>
> I am using FB1.5 final release win32 SuperServer.
>
> Regards
> Maya
>
>

This is definitely support question, and you shold not use this list for
support.
Also, please don't post HTML.

In our particular case my advice is not to drop SP, but:

1. alter existing procedures with existing set of parameters, but empty
body.
2. modify your indices, etc.
3. alter (or create) all procedures with new set of parameters and empty
body.
4. alter all procedures with real body.

Alex.