weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_04322b570a3ba688:-f852189:12babfe9a85:-7ff3): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TEST_P' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Oracle Community | user738507 | 6 years ago
  1. 0

    com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004:

    Oracle Community | 6 years ago | user738507
    weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_04322b570a3ba688:-f852189:12babfe9a85:-7ff3): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TEST_P' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  2. 0

    Problems creating physical data service to relational table

    Oracle Community | 8 years ago | 672962
    weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_2d641b85a027a9ba:43f1e2cd:11e2800892f:-7fd2): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0025: esb *SET "Value" = ?* *WHERE (("ID" = ?) AND ("Value" = ?))]: [NULL, 1, a different value|http://forums.oracle.com/forums/]: Optimistic locking failure. Update count returned by database is 0, expected 1*

    Root Cause Analysis

    1. weblogic.xml.query.exceptions.XQuerySagaException

      {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_04322b570a3ba688:-f852189:12babfe9a85:-7ff3): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TEST_P' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

      at com.bea.ld.server.update.recovery.SagaRecovery.process()
    2. com.bea.ld
      DSPSagaManager.processSagaFailure
      1. com.bea.ld.server.update.recovery.SagaRecovery.process(SagaRecovery.java:104)
      2. com.bea.ld.server.update.recovery.DSPSagaManager.processSagaFailure(DSPSagaManager.java:222)
      2 frames
    3. weblogic.xml.query
      TransactionManager.afterCompletion
      1. weblogic.xml.query.update.recovery.SagaState$2.afterCompletion(SagaState.java:87)
      2. weblogic.xml.query.transaction.TransactionManager.afterCompletion(TransactionManager.java:134)
      2 frames
    4. weblogic.transaction.internal
      ServerSCInfo.doAfterCompletion
      1. weblogic.transaction.internal.ServerSCInfo.doAfterCompletion(ServerSCInfo.java:1032)
      1 frame