Oracle apex : 5.0 Database 11g Pdf :xsl-fo Created on function :
CREATE OR REPLACE FUNCTION GET_IMG_blob2clobase64(p_blob IN BLOB)
RETURN CLOB IS
pos NUMBER := 1;
buffer VARCHAR2 (32000);
res CLOB;
lob_len NUMBER := DBMS_LOB.getlength (p_blob);
BEGIN
DBMS_LOB.createtemporary (res, TRUE);
DBMS_LOB.OPEN (res, DBMS_LOB.lob_readwrite);
LOOP buffer := UTL_RAW.cast_to_varchar2(UTL_ENCODE.base64_encode (DBMS_LOB.SUBSTR (p_blob, 20000, pos)));
IF LENGTH (buffer) > 0
THEN
DBMS\_LOB.writeappend (res, LENGTH (buffer), buffer);
END IF;
pos := pos + 20000;
EXIT WHEN pos > lob_len;
END LOOP;
RETURN res;
END FRP_GET_IMG_blob2clobase64;
This returns me Chunk Character as shown in below :
i wanted to display Image but it shows me Characters any hint!!