How to extract a sub part of a LONG ROW larger than 32kin PL/SQL ?

From: Vincent BARAT <vincent.barat_at_alcatel.fr>
Date: Thu, 16 Sep 1999 12:00:57 +0200
Message-ID: <37E0BFD9.65B3F7C9@alcatel.fr>

Hi,

I've images stored in a LONG RAW field and I'd like to send these images to a web client using the PL/SQL Web cartrige.

For the moment, the code is :

PROCEDURE DownloadGraphe(idGrph ADMIN.GRAPHES.ID_GRPH%TYPE) IS

        donneesGrph LONG RAW;

BEGIN         SELECT DONNEES_GRPH INTO donneesGrph FROM ADMIN.GRAPHES WHERE ID_GRPH = idGrph;

        owa_util.mime_header('application/octet-stream');

        htp.p(utl_raw.cast_to_varchar2(donneesGrph));

END Download Graphe;

Unfortunaly, this does not work if my images are larger then 32k, due to the oracle
32k limitation of LONG RAW...

Is ther a trick to work around this ?

Thanks a lot

--

                                Vincent BARAT

---

Web site: http://www.multimania.com/vbt/ Email (work): Vincent.Barat_at_alcatel.fr
Email (home): vbarat_at_iway.fr

"Contrary to popular belief, Unix is user friendly.  It just happens to be selective about who it makes friends with."

---

Received on Thu Sep 16 1999 - 05:00:57 CDT