Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to extract a sub part of a LONG ROW larger than 32kin PL/SQL ?
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
"Contrary to popular belief, Unix is user friendly. It just happens to be selective about who it makes friends with."
![]() |
![]() |