Wednesday, July 23, 2008

Oracle Error: PLS-00323

I encountered Oracle Error: PLS-00323 this morning. It took me time to resolve and fix it. In much cases, PLS-00323 get around you and you have to wander from here to there in Internet. Before going to Internet, you might have been tired of doing all your brains! This is all because of the oracle package that consists of a package specification and its corresponding body definition. Say, you have a package with three variables defined in your sub program and only two defined in your package body. Exactly here you get the error PLS-00323.

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

Here 'BANK_GETBYPRIMARYKEY' is my sub program.

Fixes: To be sure you can just check the matches in package specification and package body. Happy database programming.


Post a Comment

Hope you liked this post. You can leave your message or you can put your valuable suggestions on this post here. Thanks for the sharing and cooperation!

Popular Posts

Recent Articles