OAS 3.X andd blob

From: Lim Chin Yee <ccelimcy_at_nus.edu.sg>
Date: Mon, 31 May 1999 14:56:16 +0800
Message-ID: <3447D7F0AFD4D011AE0400608C14CE56103056CF@pfs01.ex.nus.edu.sg>

hi
I've installed OAS 4.0.7 and Oracle 8.0.5 and is using the follwoing script to to retrieve a blob column. Everything runs smoothly

PROCEDURE GET_PIC(STF_NUM IN VARCHAR2 default NULL) IS

 I_LOB	BLOB;
 I_AMT	NUMBER DEFAULT 30;
 I_OFF	NUMBER DEFAULT 1;
 I_RAW	RAW(4096);

BEGIN
 SELECT STF_PIC_IM INTO I_LOB

        FROM NEW_STF_PICTURE
        WHERE STF_N='00002A';
 

 OWA_UTIL.MIME_HEADER('IMAGE/JPEG');   BEGIN
    LOOP

       DBMS_LOB.READ(I_LOB,I_AMT,I_OFF,I_RAW);
       HTP.PRN(UTL_RAW.CAST_TO_VARCHAR2(I_RAW));
       I_OFF := I_OFF + I_AMT;
       I_AMT := 4096;

    END LOOP;
    EXCEPTION

       WHEN NO_DATA_FOUND THEN
            NULL;

  END;
END GET_PIC; END GET_STF_PICTURE; my concern : has anybody tried with OAS 3.X instead of OAS 4.0.7? If yes, does it work???
thanks! Received on Mon May 31 1999 - 01:56:16 CDT