This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 9345
    
    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: 9345
    
    2

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

Joined: Sep 26, 2006
Posts: 9345
    
    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
 
Don't get me started about those stupid light bulbs.
 
subject: Stored Procedure Overloading Error
 
Similar Threads
Execute Multiple SQL Queries in PL/SQL Procedure based on parameter
Named query for stored procedure
Error :java.sql.SQLException: Invalid column index
�JavaScript to Java and back again� A developers adventure
Calling stored procedure problems