Hi, I'm exposing a SOAP webservice on weblogic 12c
It uses a jdbc connection, which seems to be reused for every call I receive.
I had this issue:
A user calls the WS with invalid data. This results on my plsql procedure trying to update a table and getting the typical foreign key violation error. I trap the error and raise application error with a more descriptive text.
The problem is that subsequent calls to the webservice start returning this ORA-02067. It seems the jdbc session stays pending rollback. Shouldn't the FK exception and raise_application_error result in a rollback??