Forums Register Login

Ordinal binding and Named binding cannot be combined!

+Pie Number of slices to send: Send
I'm seeing an error when I execute cstmt.setInt(1,fromVendor); in the code below. When I step through the code I see in TRCCallableStatement.errMsgMixedBind has the following value: "Ordinal binding and Named binding cannot be combined!"

I can see fromVendor=141 and toVendor=5020 so there are no null parameters.

+Pie Number of slices to send: Send
+Pie Number of slices to send: Send
That worked. Thanks.
+Pie Number of slices to send: Send
Hi. I am getting a similar message in callable statement as "ordinal binding and named binding cannot be combined together" when calling a procedure. The proc is returning null when calling through Java, whereas in SQL developer it is not returning null. The procedure has 14 IN parameters and 1 OUT Parameter "{call EMPLOYEE_INSERT_DTLS(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}"
+Pie Number of slices to send: Send
Please continue the discussion in the other thread. Thanks!
I think he's gonna try to grab my monkey. Do we have a monkey outfit for this tiny ad?
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


Reply locked
This thread has been viewed 14321 times.
Similar Threads
Locales and Ordinal values
How to return resultset from stored procdure
Error Retreiving a resultset from an oracle stored procedure
JDBC Callable Statement JConnect2 Returning null resultset
how to get out parameter from store procedure?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 02:55:30.