Subject Re: [firebird-support] Stored Proc with blob parameter: internal error
Author Helen Borrie
At 10:22 AM 24/08/2004 +0200, you wrote:
>On Tue, Aug 24, 2004 at 05:55:02PM +1000, Helen Borrie wrote:
> >
> > Yes: a BLOB is not a string, so you'll get an error if you pass a string
> > to an SP that is expecting a BLOB. If you can't pass a BLOB every time
> the
> > SP is going to be called, then redefine it to take a string as
> > input. Inside the SP, as in DSQL, you can pass a string as input to a
> > column in your DML statements.
>Ok... but is there a way to have a stored procedure that
>takes a string of arbitrarily length?

No. The limit of a variable-length string anywhere in Firebird is 32,765

> > When passing things around your nested SPs inside the mother-procedure,
> > take care to pass BLOBs to BLOBs there, as well. You can invoke a UDF
> > inside a SP, too, if you want to "cast" a string as a BLOB...
>Is there a stored proced in the fbudf lib already?

Yes - look at 'string2blob'.