BLOB's and Webserver

I have a BLOB stored in a table. The BLOB is actually a self-extracting zip file. (filename.exe) What I want to be able to do is have a PL/SQL procedure that is executed by clicking a hyberlink that will then take this BLOB and write it to "standard out" of the users browser which would then cause the browser to open up the "save as" dialog box.

I would like to use something like the following example, but the htp.print function only allows alpha, numeric and date variable types as parameters. Does anyone has any ideas on how to get the data from the TEMP_BLOB variable back to the users browser?

Thanks for any help,

lofftjm_at_itec.suny.edu

procedure TEST is
  TEMP_BLOB blob;
begin
  select BINARYDATA
    into TEMP_BLOB
    from BLOB_TABLE
    where FILENAME = 'filename.exe';
  htp.print(TEMP_BLOB);
end TEST;

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 28 1998 - 15:22:49 CDT