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.
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Most of the times programmers fill the DataTable from database. This action fills the schema of the database table into the DataTable . We ...
-
I have found much tricks in different tutorials and forums on opening new window in asp.net web page, using JavaScript, jquery etc. Here I h...
-
The asp.net Eval() and Bind() expressions are heavily used in asp.net GridView and DetailsView data bound controls. The difference between ...
-
I have oracle database installed in my computer. My Operating system is XP. I wrote an application in asp.net. It connected to oracle databa... -
Last time I got the following error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related ... -
Last time we talked about Refreshing the parent page from child window in asp.net using javascript . This technique is useful in many scenar... -
We do have a folder (and a number of sub folders) with a number of various files in those folders (and sub folders). Now we do need to list ... -
In this post, I am explaining the button click functionality on key press in a textbox. I am using javascript to link the input textbox and ... -
Much often we open child windows from parent web page . In the child page we perform some activities, and later close the window. At the ver...
-
The default behaviour of asp.net gridview is that it hides both Gridview header and footer when no data is present. You can note the absence...
0 comments:
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!