Subject Re: [firebird-support] Re: Drop procedure
Author Martin
> 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.

Thanks
--
Martin (mailto:moirae@...)