wood burning stoves 2.0*
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: 9383
    
    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: 9383
    
    2

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

Joined: Sep 26, 2006
Posts: 9383
    
    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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stored Procedure Overloading Error