Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00304: cannot compile body of 'ETL_VALIDATION_PCK' without its specification
icon4.gif  PLS-00304: cannot compile body of 'ETL_VALIDATION_PCK' without its specification [message #407961] Fri, 12 June 2009 10:46 Go to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Hi All,

I have created one package named 'ETL_VALIDATION_PCK'.

This package contains both Specification and Body with a set of procedures.

I had compiled this package. Package successfully compiled.

After that I had removed some 3 procedure from both Spec and Pody of this package.

Now, when i compile


LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/21 PLS-00201: identifier 'ETL_VALIDATION_PCK' must be declared
1/21 PLS-00304: cannot compile body of 'ETL_VALIDATION_PCK' without
its specification

please help.

regards,
Nataraj
Re: PLS-00304: cannot compile body of 'ETL_VALIDATION_PCK' without its specification [message #407962 is a reply to message #407961] Fri, 12 June 2009 10:49 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>please help.
Correct the syntax errors.

We can not debug code we can not see.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: PLS-00304: cannot compile body of 'ETL_VALIDATION_PCK' without its specification [message #407964 is a reply to message #407961] Fri, 12 June 2009 10:56 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
PLS-00304: cannot compile body of 'string' without its specification
Cause: The compiled package specification required to compile a package body could not be found. Some possible causes follow: --the package name is misspelled --the package specification was never compiled --the compiled package specification is not accessible The package specification must be compiled before compiling the package body, and the compiler must have access to the compiled specification.
Action: Check the spelling of the package name. Compile the package specification before compiling the package body. Also, make sure the compiler has access to the compiled specification.

Previous Topic: Problem with to_char function
Next Topic: Email the output spool file name having date as filename
Goto Forum:
  


Current Time: Sun Dec 04 20:32:41 CST 2016

Total time taken to generate the page: 0.07499 seconds