Thanks, Helen.

Kurt.




----- Original Message ----
From: Helen Borrie <helebor@...>
To: firebird-support@yahoogroups.com
Sent: Thursday, August 7, 2008 3:17:00 PM
Subject: Re: [firebird-support] Message length error (encountered 58, expected 30)


At 06:05 AM 8/08/2008, you wrote:

>Greets.
>
>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

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.

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





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