PLS-00201: identifier UTL MAIL.SEND must be declared

PLS-00201: identifier ‘UTL_MAIL.SEND’ must be declared

During execution of the package use UTL Mail package for send the mail may give the error PLS-00201. It may be caused due to in configured of UTL Mail package in the database. You may configure the UTL Mail package with following script:

1. Set the Oracle Home Environment Variable

Set ORACLE_HOME=D:\Oracle\12.1.0\dbhome_1
set PATH=%ORACLE_HOME%\bin;%PATH%

2. Connect with sqlplus / as sysdba

@?\rdbms\admin\utlmail.sql;
@?\rdbms\admin\prvtmail.plb;

3. Set up the Parameter SMTP server.

ALTER SYSTEM SET smtp_out_server='address:25' SCOPE=BOTH;

4. Grant the user with required permission.

GRANT execute ON utl_mail TO NEWUSER;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.