File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Ordinal Binding and Named Binding cannot be combined together Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Ordinal Binding and Named Binding cannot be combined together" Watch "Ordinal Binding and Named Binding cannot be combined together" New topic
Author

Ordinal Binding and Named Binding cannot be combined together

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(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}" . Please help!


Priya
Martin Vajsar
Bartender

Joined: Aug 22, 2010
Posts: 2384
    
    3

Welcome to the Ranch, Priya!

You'll probably need to provide more information (see TellTheDetails ⇐ click). That would mean all of the code that pertains to the execution of this statement, preferably the definition of the stored procedure and also which database/version are you using. I believe you'll get some advice after that.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Ordinal Binding and Named Binding cannot be combined together
 
Similar Threads
Calling stored procedures from hibernate
Why variables created in Stack are not initialized
Ordinal binding and Named binding cannot be combined!
AJAX help needed
Set Chained OFF error while executing from my Bean