i tried to do:
execute procedure tst_blob('test');
and i got the same error.

the only workarround i found is to change the param type to varchar like
this:

CREATE PROCEDURE TST_BLOB (TEXT VARCHAR (100))

it works, but i am not so happy because the field is a blob.

thanks, Alan.

> -----Original Message-----
> From: PUB: Alan McDonald [mailto:alan@...]
> Sent: Martes, 02 de Septiembre (9) del 2003 9:27
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] bug in blob param
>
>
> > CREATE PROCEDURE TST_BLOB (TEXT BLOB sub_type 1 segment size 100)
> > AS
> > declare variable i integer;
> > begin
> > i = 0;
> > end
> >
> > CREATE PROCEDURE TST_BLOB2
> > AS
> > declare variable text BLOB sub_type 1 segment size 100;
> > begin
> > text = 'test';
> > execute procedure TST_BLOB(text);
> > end
> >
> > when TST_BLOB2 calls TST_BLOB raises 'internal error.' caused by
> > blob param.
> > i can't call a procedure with a blob param from another procedure!
> > is it a known bug?
> >
>
> I think it's more likely that the error occurs when you try
> to assign the
> varchar 'test' to the blob variable text.
> Alan
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
> Printer at Myinks.com. Free s/h on orders $50 or more to the
> US & Canada. http://www.c1tracking.com/l.asp?cid=5511
> http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/