Subject Bug with blobs in SPs
Author Steffen Heil
Hi

I do have a a table which has a field of type varchar(4096) and a stored
procedure, which inserts new records to that table. In a mistake, I made the
parameter for the stored procedure a blob subtype 1. Inside the stored
procedure a new record is created and the stored procedure tries to insert
the blob into the varchar field.

I know that this is an error in my stored procedure, but I also believe that
firebird is buggy in some way, because executing the stored procedure took
down the connection with an internal error message (which was not very
helpfull and even resulted in an "unknown transaction" with jaybird).

I assume the blr compiler shoud reject that faulty code in the first place,
or executing the stored procedure should result in a more sensful error
message.

Regards,
Steffen


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