Home » RDBMS Server » Server Administration » Setting up UTL_MAIL (oracle, 10g, windows xp)
Setting up UTL_MAIL [message #581584] Tue, 09 April 2013 01:58 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

I need your advice on using UTL_MAIL package.

My server version is:- 10.2.0.3.0
Here is the INIT Parameter file.

My question is, how it will affect if I configure the UTL_MAIL package by executing the Scripts ("utlmail.sql" and "prvtmail.plb")?
And setting the Parameter SMTP_OUT_SERVER=''?

Regards
Muktha
  • Attachment: INIT.txt
    (Size: 1.32KB, Downloaded 1676 times)
Re: Setting up UTL_MAIL [message #581593 is a reply to message #581584] Tue, 09 April 2013 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Affect what?

Regards
Michel
Re: Setting up UTL_MAIL [message #581594 is a reply to message #581593] Tue, 09 April 2013 02:50 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

My question is, when we execute those Scripts, one SYNONYMS getting created with the name of UTL_MAIL.

CREATE OR REPLACE PUBLIC SYNONYM utl_mail FOR sys.utl_mail;


But the server is having it already having this SYNONYMS.

And the server is already setup with UTL_SMTP to send out the mails.
Now if I set the parameter of SMTP_OUT_SERVER, will it affect the existing one?

Regards
Muktha

Re: Setting up UTL_MAIL [message #581596 is a reply to message #581594] Tue, 09 April 2013 03:15 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
I assume the existing synonym points to the same object?
You should know by now what happens if you recreate synonyms (or any other object), there's nothing special about utl_mail.
Re: Setting up UTL_MAIL [message #581600 is a reply to message #581594] Tue, 09 April 2013 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Now if I set the parameter of SMTP_OUT_SERVER, will it affect the existing one?


If you change a parameter will it affect the parameter?
Obviously yes, is it not the purpose of changing a parameter to change it?

Regards
Michel
Re: Setting up UTL_MAIL [message #581703 is a reply to message #581600] Wed, 10 April 2013 01:07 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

Yes, the synonym is pointing the same object of UTL_MAIL object from SYS user.

For the question of:
Quote:

Now if I set the parameter of SMTP_OUT_SERVER, will it affect the existing one?

My point is, we are already using UTL_SMTP to send out the mail. Now if I setup this UTL_MAIL, will affect anything / do I need to recreate the existing procedure to send out mails?

Regards
Muthu
Re: Setting up UTL_MAIL [message #581704 is a reply to message #581703] Wed, 10 April 2013 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Mail is based on SMTP, if you already set it for SMTP (and it works) there is nothing to do.

Regards
Michel
Re: Setting up UTL_MAIL [message #581720 is a reply to message #581704] Wed, 10 April 2013 02:52 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Sounds like utl_mail is already installed and configured and all you actually need to do is start using it.
Re: Setting up UTL_MAIL [message #581822 is a reply to message #581720] Thu, 11 April 2013 02:04 Go to previous message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
HI All,

Thanks a lot for the clarifications....


Regards
Muthu
Previous Topic: Single Port for Database
Next Topic: compare db objects and syn missing objects in target database
Goto Forum:
  


Current Time: Thu Mar 28 07:58:45 CDT 2024