Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sending Binary Data using HTP package

536323Jan 2 2007 — edited Jan 2 2007
Has anyone been successful in using the HTP package and its PUTRAW procedure to send binary data to a browser?

Example code shows basic idea:

create or replace
procedure test_raw as
output VARCHAR2(20);
begin
OWA_UTIL.MIME_HEADER('application/x-gzip', TRUE);
output := 'Hello World!';
HTP.PUTRAW(UTL_RAW.CAST_TO_RAW(output));
HTP.FLUSH;
end test_raw;

I receive an empty file when called from the browser.
What gives?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2007
Added on Jan 2 2007
1 comment
744 views