Subject | Re: [firebird-support] Re: Drop procedure |
---|---|
Author | Martin |
Post date | 2004-02-29T17:04:53Z |
> Martin, I have no at home nor FB neither docs, so can't beThans for your reply. You're right, it's RDB$PROCEDURE_BLR. I've
> 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.
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@...)