DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, March 4, 2015

PLS-00201: identifier 'UTL_MAIL.SEND' must be declared

If you are getting the below error while compiling the package,


then the objects related to UTL_MAIL is missing in the database.
So we have to install the respective package to clear this error.

Solution:

Run the following,

1. @?/rdbms/admin/utlmail.sql
2. @?/rdbms/admin/prvtmail.plb

SYS> @?/rdbms/admin/utlmail.sql

Package created.

Synonym created.

SYS> @?/rdbms/admin/prvtmail.plb

Package created.

Package body created.

Grant succeeded.

Package body created.

No errors.
SYS> GRANT EXECUTE ON SYS.UTL_MAIL TO <username>;


@?/rdbms/admin/utlrp

Then check for the invalid objects,

set linesize 180
set pagesize 1000
col owner format a30
col object_name format a40
select owner,object_name,object_type,status from dba_objects where status<>'VALID' order by 1,2,3,4;

No comments: