Subject Passing a blob to a stored procedure
Author williamvdw2004
Procedure
The script as I run.

CREATE PROCEDURE INSERT_TRANSACTIONEX(
TRANS_ID VARCHAR(22),
CELL_NUMBER VARCHAR(15),
THE_MESSAGE BLOB SUB_TYPE 1,
MSG_ID VARCHAR(8),
STATUS CHAR(1),
USER_ID VARCHAR(20),
VIS CHAR(1),
CONTNAME CHAR(50))
AS
BEGIN
INSERT INTO TRANSACTIONS
(TRANSID,CELLNUMBER,THEMESSAGE,MSGID,STATUS,THETIMESTAMP,USERID,
VISIBLE,CONTACTNAME)
VALUES
(:TRANS_ID, :CELL_NUMBER, :THE_MESSAGE, :MSG_ID, :STATUS, 'now', :USER
_ID,:VIS,:CONTNAME);
END;

I execute the procedure with the following line.

EXECUTE PROCEDURE INSERT_TRANSACTIONEX('1','123','test
message','123','1','testuser','T','test user')

I get an internal error in ib admin.

Thanks in advance
William