This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Call PLSQL procedure from Java, parameter error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Call PLSQL procedure from Java, parameter error" Watch "Call PLSQL procedure from Java, parameter error" New topic
Author

Call PLSQL procedure from Java, parameter error

Gab Smith
Greenhorn

Joined: Jan 30, 2012
Posts: 1
I've got this oracle plsql procedure:



I like to call from java:


But it'a not work, throw parameter collision error.



I try change


to


but not works.

What's the problem?

Please help! Thanks for all reply!

Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

Welcome to Coderanch!

I'm not sure this is going to help, but I'd try binding the parameters by position, not by name.

If it doesn't help, post full stack trace of the exception you're getting, including the line at which it occurs.
Tina Smith
Ranch Hand

Joined: Jul 21, 2011
Posts: 171
    
    5





These look like they might cause a problem? Mainly the first one since you can't have two parameters named p_blob.


Everything is theoretically impossible, until it is done. ~Robert A. Heinlein
Ravi Majety
Ranch Hand

Joined: Feb 26, 2009
Posts: 59

Please post some StacTrace . It would help others to resolve the issue.

Let us know Is this statement failed even though you set the input and output parameters to CallableStatement using indexing as below.

 
 
subject: Call PLSQL procedure from Java, parameter error
 
Similar Threads
Calling Oracle Stored Procedure
Error :java.sql.SQLException: Invalid column index
wrong number or types of arguments in call to 'P_RETRIEVE_OPPTY_ORDER_STATUS'
getting error for fetching result from oarcle with outparameter
Help with: java.sql.SQLException: ORA-01008: not all variables bound