Re: PLS-00323 error

Bala Bulusu (bb74_at_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:                    <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->