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

2. Connect with sqlplus / as sysdba


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;


Leave a Reply

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

You are commenting using your 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.