Re: Return BLOB from Stored Procedure

[Charles Wilt <charles.wilt@xxxxxxxxx>]

You're missing the point.

The UNC path to the file is not accessible to the web client.  Nor do
I want to make it accessible.

I could load the PDF into a BLOB column in a temporary table then
return a cursor to table.

I simply want to know if there's any way to bypass the insertion of
the PDF into the temporary table.  In other words, build the result
set with a BLOB column in memory and pass that back using SET RESULT
SETS or similar.

Charles


On Fri, Feb 13, 2009 at 10:32 AM, Jason Abreu <abreuj@xxxxxxxxxxxxxxxxx> wrote:
> Of course you can return a BLOB (Binary Large OBject) through sql.
>
> But, your description has nothing to do with a BLOB.
> You say your PDF file is in the IFS; I'm guessing you mean stored in a
> directory and not in a database table.  A BLOB is a datatype for a
> database table column and is returned to the calling language as a
> binary stream.
>
> Since your file is not stored within a database table, you cannot return
> it as a database table column, regardless of datatype.
>
> You will need to do what Walden suggested and store a UNC path within
> the database table and return the path so your calling language knows
> where to get the actual file from.
>
> --Jason