BLOB and HTP package
Hello,
I'm dealing with an application with BLOBS in Oracle database. There is mime-type in the db and the content (i.e. application/msword and word document itself as BLOB).
I'm trying to select the content and put it into html browser, it's something like following:
v_amount binary_integer := 1024;
v_position integer := 1024;
buffer raw(32767);
...
owa_util.mime_header(t_doc(1).mime_type);
loop
dbms_lob.read(t_doc(1).content, v_amount, v_position, buffer);
htp.p(buffer);
v_position := v_position + v_amount;
end loop;
exception
when no_data_found then
...
The procedure send the right mime-type so the browser open corresponding application and also sen the data. But the data is bunch of hexa numbers, so the application cannot deal them properly. Can anybody know how to transfer the hexa numbers to raw data?
Jan Mura