Subject RE: [ib-support] Direct modification to system tables to...
Author Kaputnik
My experience is, that once your SP-BLR is invalid, you will have a
corrupted database.
I wasn't able to recompile the SP as long as the contained BLR was
invalid, and the same goes with triggers...So I am extremely careful now
when it comes to changing a productive database with SP's....normally, I
extract the DDL of all SP'S, drop them all and recreate them after
finishing my work.

That is only my experience, and perhaps I did something wrong :-)

CU, Nick

> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Tuesday, July 10, 2001 9:28 AM
> To:
> Subject: Re: [ib-support] Direct modification to system tables to...
> > Just be crafeul when there are dependencies on that field in (for
> > example) stored procedures.
> > Check these dependencies before you alter the domain.
> > If necessary alter the procedures to an empty body, change the
> > change the procedure (and it's variables) according to your needs
> > then re-add the procedure.
> Thanks for the additional tips. How about if I just go through and
> all
> the stored procedure so that they are recompiled? I am not certain I
> sure all of these dependencies were eliminated.
> I usually do this when I am changing the stored procedures input
> parameters
> and such so I'm used to the commenting stuff out. That is a very
> suggestion for sure. In fact, I just got done changing a bunch of
> procedures doing that...
> Seems I need to add a column dependency tracker to IB_SQL (notice I
> call it IB_WISQL anymore since we are LINUX bound).
> Cheers,
> Jason Wharton
> CPS - Mesa AZ