utl_smtp.rcpt and multiple emails

From: jobs <jobs_at_webdos.com>
Date: Wed, 26 Sep 2007 07:57:44 -0700
Message-ID: <1190818664.641035.133440@r29g2000hsg.googlegroups.com>

I'm trying to email several addresses. My script works great when it's only going to one address, but if I attempt to send to mulitiple nothing get's sent. I've tried delimiting them with space, comma and semicolon:

usage:

declare
  esendto varchar2(100);
  esubject varchar2(100);
  ebody varchar2(2000);
begin

    esendto := 'me_at_me.com,you_at_you.com; --does not
--esendto := 'me_at_me.com;you_at_you.com; --does not
--esendto := 'me_at_me.com you_at_you.com; --does not
--esendto := 'me_at_me.com; --works

    esubject := 'Test email from Oracle ...................... long

subject';
  ebody :='10'|| utl_tcp.CRLF;
  EMAIL(esendto,esubject,ebody);
end;

the email procedure::

CREATE OR REPLACE PROCEDURE "EMAIL"(v_rcpt in varchar2,

                                    v_subject in varchar2,
                                    texto     in varchar2) as

  c utl_smtp.connection;
  PROCEDURE header(name IN VARCHAR2, header IN VARCHAR2) AS   BEGIN
    utl_smtp.write_data(c, name || ': ' || header || utl_tcp.CRLF);   END;
BEGIN
  c := utl_smtp.open_connection('mysmtp.mydomain.com');

  utl_smtp.helo(c, 'mysmtp.mydomain.com');
  utl_smtp.mail(c, 'job_at_mydomain.com');
  utl_smtp.rcpt(c, v_rcpt);
  utl_smtp.open_data(c);
  header('From', '"JOB" <job_at_mydomain.com>');

  header('To', v_rcpt);
  header('Subject', v_subject);

  utl_smtp.write_data(c, utl_tcp.crlf || texto || utl_tcp.CRLF);
  utl_smtp.close_data(c);
  utl_smtp.quit(c);

END; Thanks for any help or information. Received on Wed Sep 26 2007 - 09:57:44 CDT