Hi,

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

You're not passing a blob, you're passing a string.

BLOB <> string.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com