Re: Oracle Java Question

From: <amerar_at_iwc.net>
Date: 29 Jun 2005 07:19:18 -0700
Message-ID: <1120054758.618618.204460@g47g2000cwa.googlegroups.com>

I went with the Java email package because it was suggested to me by some people who work over at Oracle.........

At any rate, I'm trying to trick this thing into displaying the attachment as inline. Maybe that will work?

I have to figure out the proper string for the attachment type though:

create or replace function send(

  p_from                  in varchar2,
  p_to                    in varchar2,
  p_cc                    in varchar2,
  p_bcc                   in varchar2,
  p_subject               in varchar2,
  p_body                  in varchar2,
  p_smtp_host             in varchar2,
  p_attachment_data       in bfile,
  p_attachment_type       in varchar2,

  p_attachment_file_name in varchar2) return number as

  language java name 'mail.send( java.lang.String,
                                 java.lang.String,
                                 java.lang.String,
                                 java.lang.String,
                                 java.lang.String,
                                 java.lang.String,
                                 java.lang.String,
                                 oracle.sql.BFILE,
                                 java.lang.String,
                                 java.lang.String
                        ) return oracle.sql.NUMBER';

Received on Wed Jun 29 2005 - 09:19:18 CDT