[9] write a pl/sql block to send that attachment, i did here sending it to my other account........
Code:
[email protected]L> set serveroutput on size 1000000
[email protected]L> exec dbms_java.set_output( 1000000 )

PL/SQL procedure successfully completed.

[email protected]L> declare
  2    ret_code number;
  3  begin
  4    for i in (select theBlob from demo )
  5    loop
  6      ret_code := send(
  7                    p_from => '[email protected]',
  8                    p_to => '[email protected]',
  9                    p_cc => NULL,
 10                    p_bcc => NULL,
 11                    p_subject => 'Use the attached Zip file',
 12                    p_body => 'to send email with attachments....',
 13                    p_smtp_host => 'mail.home.nl',
 14                    p_attachment_data => i.theBlob,
 15                    p_attachment_type => 'application/winzip',
 16                    p_attachment_file_name => 'OTNToolbar.zip');
 17      if ret_code = 1 then
 18        dbms_output.put_line ('Successfully sent message...');
 19      else
 20        dbms_output.put_line ('Failed to send message...');
 21      end if;
 22    end loop;
 23  end;
 24  /
Successfully sent message...

PL/SQL procedure successfully completed.
And this way i received the toolbar.zip on my hotmail address.

HTH

Cheers

Tarry