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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 9243
    
    1

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, SCBCD Hints - Demnachst, SCDJWS - Auch Demnachst
Did a rm -R / to find out that I lost my entire Linux installation!
Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9243
    
    1

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

Joined: Sep 26, 2006
Posts: 9243
    
    1

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
 
Similar Threads
�JavaScript to Java and back again� A developers adventure
Calling stored procedure problems
Execute Multiple SQL Queries in PL/SQL Procedure based on parameter
Error :java.sql.SQLException: Invalid column index
Named query for stored procedure