Subject Re: UDFs returning BLOB cause error -804
Author mircostange
> as the return parameter. The real problem is that dsql doesn't
have a
> definition into which to put the output, since it doesn't have an
existing
> blob column to refer to.

Ok, got it. In my case I explicitly would not like to store the BLOB
anywhere in the db. I have a table with EMF BLOBs (vector graphs,
small, scalable, ...) but need to convert them into BMPs for printing
(Crystal Reports doesn't like EMFs... beats me why).

I figured out that it works whith a view. I can do

create view sampleattachment_bmp (bmp) as
select emf2bmp(data) from sampleattachment

where "data" would be a blob and emf2bmp would be an udf accepting a
blob and returning one.

I can then easily execute

select bmp from sampleattachment_bmp

Fine!

Regarding the error code. I am using the "old" beta2, mainly because
the RC2 doesn't come with ibconsole, etc. (Why? But this is another
story). Probably this is the cause.

Thank you

Mirco