PLS-00323 error in oracle

Question

I am creating a procedure in a package. I have updated the specification of the package and then when i am updating the body of the package it shows me the following error.

[Error] PLS-00323 (314: 13): PLS-00323: subprogram or cursor 'INSERT_CUSTOMER_ADDRESS' is declared in a package specification and must be defined in the package body

N.B.: INSERT_CUSTOMER_ADDRESS is my procedure name.

Answer 1

If you create a procedure in the package specification it must be created\implemented in the package body. Consider your package specification as an interface and the package body as its implementation.

Answer 2

Always the declaration on the pkg spec and the pkg body should be same.

Which means the procedure / function declared in pkg spec ( includes name of the procedure / function , Parameter type ) should be exactly same.

Note : when oracle compiles the pkg for above error case, it won't give you the exact line no.