Forums Register Login

Call PLSQL procedure from Java, parameter error

+Pie Number of slices to send: Send
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!

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
 





These look like they might cause a problem? Mainly the first one since you can't have two parameters named p_blob.
+Pie Number of slices to send: Send
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.

No matter. Try again. Fail again. Fail better. This time, do it with this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 2984 times.
Similar Threads
getting error for fetching result from oarcle with outparameter
Error :java.sql.SQLException: Invalid column index
Help with: java.sql.SQLException: ORA-01008: not all variables bound
wrong number or types of arguments in call to 'P_RETRIEVE_OPPTY_ORDER_STATUS'
Calling Oracle Stored Procedure
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 22:35:10.