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:
Error:
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_MAIL.SEND' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Solution:
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;
Comments
Tags: GRANT execute, Grant user permission.oracle dba, PLS-00201, SMTP server, UTL_MAIL.SEND, utlmail, utlmail.sql