aspose file tools*
The moose likes Oracle/OAS and the fly likes Stored Procedure Overloading Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Stored Procedure Overloading Error" Watch "Stored Procedure Overloading Error" New topic
Author

Stored Procedure Overloading Error

Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9519
    
    2

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?


SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9519
    
    2

I'm trying this in Oracle database.
Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9519
    
    2

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Stored Procedure Overloading Error