Subject: Re: PLS-00323 error
Newsgroups: comp.databases.oracle.server
References: <33B444A3.3CE2C210@pantheon.yale.edu>
Reply-To: akaplan@interaccess.com
Distribution: 

Bala Bulusu (bb74@pantheon.yale.edu) wrote:
: Hi!!
: Is anyone familiar with the following error message:
: PLS-00323: subprogram or cursor 'CREATE_EMPLOYEE' is declared in
: a package specification and must be defined in the package body
: I tried recompiling the database package header and body after changing
: the procedure name hoping it would work... no luck!
: I'd appreciate any feedback...
: Thanks,
: B.
Bala,

According to my documentation, the Oracle PLS 323:

subprogram 'name' is declared in a package specification and must be
defined in the package body

Cause: You placed a subprogram specification in a package specification,
but neglected to place the corresponding subprogram body in the package
body. The package body implements the package specification, so the
package body must contain the definition of every subprogram declared in
the pckage specification.

Action: Check your spelling of the subprogram name. If necessary, add the
missing subprogram body to the package body.

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 70+ technical tips, visit my Web Page:                    <->
<->                                                               <->
<->              www.arikaplan.com                                <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page >Back to Ari Kaplan's Home Page