Subject | Re: [firebird-support] Message length error (encountered 58, expected 30) |
---|---|
Author | Helen Borrie |
Post date | 2008-08-07T22:17Z |
At 06:05 AM 8/08/2008, you wrote:
Another that comes to mind is attempting to pass a string in a BLOB parameter...i.e., it's legal to do
insert into aTable (id, MyTextBlob)
values (99, 'This is a string')
But if the statement is
insert into aTable (id, MyTextBlob)
values (?, ?)
then you will get the message length error if you try to assign a string to the second parameter.
./heLen
>Greets.The "message length" error refers to the size of structures crossing the wire so it's pretty generic. One place to look would be in parameters that you are passing in stored procedure calls and DSQL requests. A related source of this error pops up with Delphi programmers from time to time, where their application is trying to SELECT from an executable procedure.
>
>I received that error message from code that was apparently working. It selects four long values from the DB, places them in a struct and pushes the struct to the back of a list.
>
>The Firebird Book says it is error -901, and the symbol is "port_len", but it is not clear how to fix the issue; that is the only reference to it in the book.
>
>Can anyone drop me a clue as to what I'm doing wrong on:
>Ubuntu 8.04
>firebird2.1-super
Another that comes to mind is attempting to pass a string in a BLOB parameter...i.e., it's legal to do
insert into aTable (id, MyTextBlob)
values (99, 'This is a string')
But if the statement is
insert into aTable (id, MyTextBlob)
values (?, ?)
then you will get the message length error if you try to assign a string to the second parameter.
./heLen