Subject RE: [firebird-support] Re: Problems with table RDB$PROCEDURES
Author Marc Geldon
I mean if I login to the database maybe with Marathon. Go to the column, edit the column (for example change the first char and then back to the original), save it and commit it, I get this error.

So nothing changed. You know what I mean?

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Sat 24.01.2004 19:05
To: Marc Geldon (PRO IT SYSTEMS)
Cc: firebird-support
Subject: [firebird-support] Re: Problems with table RDB$PROCEDURES

At 12:28 PM 1/24/2004, Marc Geldon (PRO IT SYSTEMS) wrote:
>If I try to update a row in RDB$PROCEDURES (I talk about the specific
>column RDB$PROCEDURE_BLR) and try to insert data, everytime I get the
>following message:
>invalid request BLR at offset 0
>corrupt system table
>unsupported BLR version (expected 4, encountered 98)

Updating BLR fields directly is not a usual thing to do,
though gbak and a few of the other utilities do it. BLR
(Binary Language Representation) is a binary coded relational
statement, or in other words, gook. By convention, a BLR
string starts with the version number which should be 4
or 5. The "expected 4, encountered 98" part of the message
says that the string you stored started with a 98 ('b') (hex

>I get the same message if I update the row and set the same data that
>already was in the column.

Are you sure it's exactly the same?
>What is wrong here? Is that a bug?

I don't know exactly what's going on but I doubt that it's a
bug. May I ask why you want to update that field?



Yahoo! Groups Sponsor
click here <*>


Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to: <>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <> .

[Non-text portions of this message have been removed]