Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Ordinal binding and Named binding cannot be combined! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

Ordinal binding and Named binding cannot be combined!

Keith Larsen
Greenhorn

Joined: May 04, 2011
Posts: 2

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.

Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Keith Larsen
Greenhorn

Joined: May 04, 2011
Posts: 2

That worked. Thanks.
priya chitra
Greenhorn

Joined: Jan 04, 2013
Posts: 2

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(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}"


Priya
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3456
    
  47

Please continue the discussion in the other thread. Thanks!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Ordinal binding and Named binding cannot be combined!
 
Similar Threads
Error Retreiving a resultset from an oracle stored procedure
How to return resultset from stored procdure
JDBC Callable Statement JConnect2 Returning null resultset
Locales and Ordinal values
how to get out parameter from store procedure?