--- In firebird-support@yahoogroups.com, Martin <moirae@c...> wrote:

> > Martin, I have no at home nor FB neither docs, so can't be
> > sure in exact column name for BLR, but general idea is:
>
> > Update RDB$PROCEDURES Set RDB$PROCEDURE_BLR=''
> > Where RDB$PROCEDURE_NAME='THIS_PROCEDURE'
>
> > and then Drop Procedure THIS_PROCEDURE.
>
> > Best regards,
> > Alexander.
>
> Thans for your reply. You're right, it's RDB$PROCEDURE_BLR. I've
> tried it (using IBExpert). Query executed, 1 record was updated.
> But when I wanted to commit, it ended with:
>
> "Cannot commit transaction:
> Invalid token.
> invalid request BLR at offset 0.
> corrupt system table.
> unsupported BLR version (expected 4, encountered 0)."
>
> OK, what can I do now? DB is running on FB 1.

Martin, did'nt made it myself for years, so... Maybe

a) try with Null instead of ''
b) try with isql which don't perform metadata cashing and other
background transations and statements like IBExpert.

Best regards,
Alexander.