Home » SQL & PL/SQL » SQL & PL/SQL » Working With UTL_SMTP (9i Windows)
Working With UTL_SMTP [message #322424] Fri, 23 May 2008 08:36 Go to next message
nirajsharmacpr
Messages: 3
Registered: May 2008
Location: Mumbai
Junior Member
Hi List
i am Using the Package where one Parameter take the String this is ',' seprated and this variable populated by table cursor
eg
v_email := v_email ||cur.email ||',';
V_EMAIL:= replace (V_EMAIL, ',' , ''',''');

then v_email pass in the Package
like

pkg_email.send
( p_sender_email => 'abc@XXXXXX.com',
p_from => 'abc@XXXXXX.com',
p_to => pkg_email.array(''''|| v_email||'''' ),
p_cc => pkg_email.array( 'abc@XXXXXX.com' ),

here
i am want to passing the values in "p_to" as 'abc@xxxx.com','xyz@xxxx.com'

but here i am getting the error
ORA-29279: SMTP permanent error: 501 5.5.4 Invalid Address
Re: Working With UTL_SMTP [message #322426 is a reply to message #322424] Fri, 23 May 2008 08:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-29279: SMTP permanent error: %s
 *Cause:  A SMTP permanent error occurred.
 *Action: Correct the error and retry the SMTP operation.

Quote:
Invalid Address

Regards
Michel
Re: Working With UTL_SMTP [message #322427 is a reply to message #322424] Fri, 23 May 2008 08:42 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
I suspect that the SMTP server does not like the single quote marks
Re: Working With UTL_SMTP [message #590605 is a reply to message #322427] Fri, 19 July 2013 14:15 Go to previous message
angelina1984
Messages: 12
Registered: July 2013
Location: USA
Junior Member
It could be that the logical network device is inactive.
if you can log-in as super user , you can turn it on

su -
chkconfig NetworkManager off
chkconfig network on
Previous Topic: SQL server error Occured.
Next Topic: Find Difference
Goto Forum:
  


Current Time: Sat Dec 10 22:20:54 CST 2016

Total time taken to generate the page: 0.04523 seconds