Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Russell Ray
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2596
12
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic