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

[Russell Ray]

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]

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