PL/SQL (MOSC)

MOSC Banner

PLS-00304: cannot compile body of 'UTL_MAIL' without its specification

edited Feb 14, 2014 11:31AM in PL/SQL (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center