Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

Issue

• After Oracle database upgrade to 11.2.0.4, server fails to commit transaction with following cause :

Caused by: javax.resource.ResourceException: SQLException
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:1192)
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:99)
    at org.jboss.jca.core.tx.jbossts.LocalXAResourceImpl.commit(LocalXAResourceImpl.java:175)
    ... 51 more
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored