--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 09:34 AM 10/06/2004 +0000, you wrote:
> >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.
>
> The string 'test message' isn't a blob, it's a string. The

procedure

> expects a blob as input. If you're using Firebird, change the

input

> parameter declaration to a suitably sized varchar and it should

compile. If

> you're using InterBase, you'll have to do something a bit more

complicated

> inside the SP to convert the string to a blob, i.e. call a UDF such

as

> String2Blob.
>
> /heLen

I wanted to use a BLOB to get around the size limit associated with a
varchar. Is there a way I can pass a BLOB directly form a SQL
statement?

Regards
William