OraFAQ Forum: SQL & PL/SQL » Working With UTL

Home » SQL & PL/SQL » SQL & PL/SQL » Working With UTL_SMTP (9i Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Working With UTL_SMTP [message #322424]

Fri, 23 May 2008 08:36

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

Report message to a moderator

Re: Working With UTL_SMTP [message #322426 is a reply to message #322424]

Fri, 23 May 2008 08:42

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Working With UTL_SMTP [message #322427 is a reply to message #322424]

Fri, 23 May 2008 08:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I suspect that the SMTP server does not like the single quote marks

Report message to a moderator

Re: Working With UTL_SMTP [message #590605 is a reply to message #322427]

Fri, 19 July 2013 14:15

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

Report message to a moderator

Previous Topic:	SQL server error Occured.
Next Topic:	Find Difference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 26 23:53:59 CDT 2025