Re: Oracle Java Mail Question

From: <amerar_at_iwc.net>
Date: 28 Jun 2005 11:24:40 -0700
Message-ID: <1119983079.973031.190300_at_g14g2000cwa.googlegroups.com>

[Quoted] I appreciate the response. One would think that text/html is the default. But, maybe not. At any rate, I am not a Java programmer, and do not know a lot about Java. So, I may need some help here.

[Quoted] I'll take a look at what Java routines there are. I installed the Oracle JVM per the manual and made no other changes. I'm not sure where to look.

[Quoted] The routine does not accept a header or content type. Only the basic fields; from, to, cc, subject, attachment.

[Quoted] I've attached the call to the routine for your review in case you have some idea.....

[Quoted] 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';

Thank again. Received on Tue Jun 28 2005 - 20:24:40 CEST