File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Stored Procedure Overloading Error Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Reply 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: 8457

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: 8457

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

Joined: Sep 26, 2006
Posts: 8457

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
 
 
subject: Stored Procedure Overloading Error
 
Threads others viewed
Execute Multiple SQL Queries in PL/SQL Procedure based on parameter
Named query for stored procedure
�JavaScript to Java and back again� A developers adventure
Calling stored procedure problems
Error :java.sql.SQLException: Invalid column index
WebSphere development made easy
without the weight of IBM tools
http://www.myeclipseide.com