Can a stored procedure return a BLOB

From: <gaop_at_my-deja.com>
Date: Thu, 23 Dec 1999 16:57:31 GMT
Message-ID: <83tk8d$n0r$1@nnrp1.deja.com>

I have a stored procedure that creates a temp BLOB, populates it with data from a column value, and returns it. The temp BLOB has session duration. For example, the stored procedure, FSC.RENDER.TOGIF can be used as the following:

select fsc.render.togif(grid) from mygrid;

where grid is a column of an object type in the table mygrid, and the function returns a temp BLOB.

The function worked fine when invoked from SQL Plus client, but when invoked from OCI or JDBC clients, it failed with an error:

ORA-22922: nonexistent LOB value

My questions are:

(1) can a stored procedure returns a temp BLOB at all?
(2) how to return a BLOB if a temp BLOB is not allowed?
(3) are there other alternatives for returning a large chunk of

binary data, such as images?

Thanks for any help.

Gao Peng
gao.peng_at_formida.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 23 1999 - 10:57:31 CST