you probably need to execute utl_smtp.rcpt once for each address.
Raj
On 12/5/05, Subbiah, Nagarajan <Nagarajan.Subbiah@(protected)> wrote: > > Hi, > > I am using the below package for the send mail functionality from Oracle. > When I use pass the multiple e-mail addresses (using comma or semicolon > delimeter), I get the following error message. Do I have to parse and > split > the e-mail variable and call this package multiple times OR is there a way > to use the multiple e-mail addresses in the UTL_SMTP? >
you probably need to execute utl_smtp.rcpt once for each address.<br><br>Raj<br ><br><div><span class="gmail_quote">On 12/5/05, <b class="gmail_sendername" >Subbiah, Nagarajan</b> <<a href="mailto:Nagarajan.Subbiah@(protected)"> Nagarajan.Subbiah@(protected)</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br><br>I am using the below package for the send mail functionality from Oracle. <br>When I use pass the multiple e-mail addresses (using comma or semicolon<br >delimeter), I get the following error message. Do I have to parse and split<br >the e-mail variable and call this package multiple times OR is there a way <br>to use the multiple e-mail addresses in the UTL_SMTP?<br></blockquote></div ><br>