| Setting up UTL_MAIL [message #581584] |
Tue, 09 April 2013 01:58  |
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 1988 times)
|
|
|
|
|
|
| Re: Setting up UTL_MAIL [message #581594 is a reply to message #581593] |
Tue, 09 April 2013 02:50  |
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 |
cookiemonster
Messages: 13959
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 #581703 is a reply to message #581600] |
Wed, 10 April 2013 01:07 |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
