CallableStatement from JDBC and Direct Call from SQL Developer get different results
posted 6 years ago
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.