Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00323: subprogram or cursor 'string' is declared in a
package specification and must be defined in the package body



PLS-00323: subprogram or cursor 'string' is declared in a package specification and must ..

Answer / guest

Cause: A subprogram specification was placed in a package
specification, but the corresponding subprogram body was not
placed 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 package
specification.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11113: value of string must be one of string

1 Answers  


ORA-01002: fetch out of sequence

1 Answers  


ORA-22059: buffer size [string] is too small - [string] is needed

1 Answers  


ORA-28530: Heterogeneous Services initialization error in NLS language ID

1 Answers  


TNS-01017: set|show current_listener [<listener_name>]: sets|shows current listener

1 Answers  






ORA-00064: object is too large to allocate on this O/S (string,string)

1 Answers  


ORA-02780: Name given for the core dump directory is invalid

1 Answers  


ORA-26723: user "string" requires the role "string"

1 Answers  


ORA-13787: missing SQL profile for statement object "string" for tuning task "string"

1 Answers  


ORA-14504: syntax not supported for analyze

1 Answers  


ORA-27009: skgfwrt: cannot write to file opened for read

1 Answers  


NZE-29237: the cryptographic engine could not finish the algorithm

1 Answers  






Categories