Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_MAIL, ORA-29261: bad argument

Erkan HaspulatJul 14 2010 — edited Jul 14 2010
Hi, I'm sort of a PLSQL newbie and this is my first post here. I have seen that people asked this question before and I've also seen the replies involved. But here is the situation:
BEGIN
        UTL_MAIL.SEND('foo@bar.com', 
            'bar@foo.com');
END;
This is the code I'm trying to run. But I get the error specified in the title. Here's what I've tried so far; I've installed UTl_MAIL packages since they're not pre-installed according to http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_mail.htm#i1001699 , and then I've set the SMTP_OUT parameter.
show parameter smtp_out_server
---
smtp_out_server                      string   10.200.123.135
But I still get the error. I'm running on 10g release 2 XE on my local, and I'm able to ping the mail server.

Edited by: user1156042 on 14-Jul-2010 01:37
This post has been answered by Billy Verreynne on Jul 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2010
Added on Jul 14 2010
4 comments
13,396 views