• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored Procedure Overloading Error

 
Joe Harry
Ranch Hand
Posts: 10111
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guys,

I have a Stored Procedure declaration which is overloaded as below:



In the package body, I have the following call:



When I tried to execute the statement, I got following error on LINE XX mentioned above:



What could be wrong here?

 
Joe Harry
Ranch Hand
Posts: 10111
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm trying this in Oracle database.
 
Joe Harry
Ranch Hand
Posts: 10111
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Managed to get rid of the problem. There were primarily two mistakes that I did:

(1) Stored Procedures as opposed to functions does not return any value
(2) The result code was missing in the parameter list to the overloaded stored proc
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic