Home » SQL & PL/SQL » SQL & PL/SQL » 'UTL_SMTP' (Oracle 10g)
'UTL_SMTP' [message #585146] Wed, 22 May 2013 08:21 Go to next message
Baharul
Messages: 3
Registered: May 2013
Junior Member
When I am running script in oracle 10g ,getting error message as "PLS-00201: identifier 'UTL_SMTP' must be declared".

Any one please help me how to declare identifier 'UTL_SMTP' in oracle 10g or how to give execute access to current user
Re: 'UTL_SMTP' [message #585148 is a reply to message #585146] Wed, 22 May 2013 08:24 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ UTL_SMPT is not installed by default
2/ use UTL_MAIL instead (unless you have a very specific need that prevents from using it)

Regards
Michel
Re: 'UTL_SMTP' [message #585154 is a reply to message #585148] Wed, 22 May 2013 08:56 Go to previous messageGo to next message
Baharul
Messages: 3
Registered: May 2013
Junior Member
Hello All,

Thank you Michel for your feed back.

I will definitely with this option.

Thanks
Baharul
Re: 'UTL_SMTP' [message #585157 is a reply to message #585154] Wed, 22 May 2013 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you (or your DBA) has to execute utlmail.sql and prvtmail.plb with SYS account.

Regards
Michel
Re: 'UTL_SMTP' [message #585476 is a reply to message #585157] Sun, 26 May 2013 04:22 Go to previous messageGo to next message
Baharul
Messages: 3
Registered: May 2013
Junior Member
Hello Michel,
As you suggested to use UTL_MAIL instead of UTL_SMPT if don't have specific requirement. But I can't replace UTL_SMTP as the script itself is coming along the 3rd party software package.So I can't edit it in run time.
And again looking with SYS account,I can find UTL_SMTP is present and in compiling it is giving no error and also I have provided all access to the current user.But still getting the same error "PLS-00201: identifier 'UTL_SMTP' must be declared" when I am compiling my original script.
Is there any way to declare this identifier for the current/local user with all possible function or any other way to get rid of this difficulty.

Any kind of help is always welcome.

Regards
Baharul
Re: 'UTL_SMTP' [message #585477 is a reply to message #585476] Sun, 26 May 2013 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
And again looking with SYS account,I can find UTL_SMTP is present and in compiling it is giving no error and also I have provided all access to the current user.But still getting the same error "PLS-00201: identifier 'UTL_SMTP' must be declared" when I am compiling my original script.


You have to show what you did and got.
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Regards
Michel
Re: 'UTL_SMTP' [message #585631 is a reply to message #585476] Tue, 28 May 2013 08:36 Go to previous message
joy_division
Messages: 4489
Registered: February 2005
Location: East Coast USA
Senior Member
Baharul wrote on Sun, 26 May 2013 05:22

And again looking with SYS account,I can find UTL_SMTP is present and in compiling it is giving no error and also I have provided all access to the current user.


But did you "So you (or your DBA) has to execute utlmail.sql and prvtmail.plb with SYS account." as Michel said?
Previous Topic: Can't finish sub - query
Next Topic: CLOB TO VARCHAR
Goto Forum:
  


Current Time: Tue Jul 29 11:02:59 CDT 2014

Total time taken to generate the page: 0.08772 seconds