PLS-00304: cannot compile body of 'UTL_MAIL' without its specification
Hi ,
I am executing a packagae see below error , Can someone please help
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 3 09:34:59 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> GRANT EXECUTE ON UTL_MAIL TO ADMIN;
Grant succeeded.
SQL> @prvtmail.plb
Package created.
Package body created.
Grant succeeded.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY UTL_MAIL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00304: cannot compile body of 'UTL_MAIL' without its