aspose file tools*
The moose likes JDBC and the fly likes CallableStatement from JDBC and Direct Call from SQL Developer get different results 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
Bookmark "CallableStatement from JDBC and Direct Call from SQL Developer get different results" Watch "CallableStatement from JDBC and Direct Call from SQL Developer get different results" New topic
Author

CallableStatement from JDBC and Direct Call from SQL Developer get different results

Russell Ray
Ranch Hand

Joined: Apr 25, 2005
Posts: 116
Let me explain what I am trying to accomplish.

First I have a store procedure running on Oracle 10g. When I run the store procedure in SQL Developer, I have no problems. The store procedure compiles correctly and runs without error. Next I move the call out to a Java class and use a jdbc connection. When I make the call, I get a foriegn constraint error and the data is not loaded properly. The input is the same. The execute operation is not in a loop.

Your suggestions would be greatly appreciated. I have been told the CallableStatment could be getting called twice, but I don't see how.

Thanks for your suggestions.

Russ
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2477
    
    7

Please post the piece of code that shows what you are trying to do, and the exact errors you get.
We need more info to help you.

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CallableStatement from JDBC and Direct Call from SQL Developer get different results
 
Similar Threads
Using JDBC for a remote call in Oracle
Stored procedure call removes spaces in text
PreparedStatement and CallableStatement?
Invalid parameter binding(s)--Please Help!
java.sql.SQLException: ORA-00900: invalid SQL statement