Subject Re: [firebird-support] Stored Proc with blob parameter: internal error
Author Daniel Albuschat
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 BLOB
> column in your DML statements.

Ok... but is there a way to have a stored procedure that
takes a string of arbitrarily length?

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

Daniel Albuschat

eat(this); // delicious suicide