com.bea.dsp.das.exception.DASException

weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_447b134168421dc5:564de77e:12775210007:-7ff2): 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 'PAG_TES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Solutions on the web16

  • via Oracle Community by 761210, 10 months ago
    }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 'PAG_TES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  • weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_596ba32b1ff8d8a4:181f0b20:11f92ed2529:-7fde): java.lang.RuntimeException: ORA-06550: Zeile 1, Spalte 7: PLS-00306: Falsche Anzahl oder Typen von Argumenten in Aufruf von 'GETRESULT' ORA-06550: Zeile 1, Spalte 7: PL/SQL: Statement ignored
  • via Oracle Community by 718215, 10 months ago
    weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_64f908a41cb48aeb:51ff32b4:1233d8ca55c:-7fdb): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0000: Relational wrapper exception. could not find the corresponding sql type for output parameter P_RECORDSET
  • Stack trace

    • com.bea.dsp.das.exception.DASException: weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_447b134168421dc5:564de77e:12775210007:-7ff2): 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 'PAG_TES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored at com.bea.dsp.das.ejb.EJBClient.invokeOperation(EJBClient.java:160) at com.bea.dsp.das.DataAccessServiceImpl.invokeOperation(DataAccessServiceImpl.java:171) at com.bea.dsp.das.DataAccessServiceImpl.invoke(DataAccessServiceImpl.java:122) at com.bea.dsp.ide.xquery.views.test.QueryExecutor.invokeFunctionOrProcedure(QueryExecutor.java:113) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.getFunctionExecutionResult(XQueryTestView.java:1041) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.executeFunction(XQueryTestView.java:1176) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelectedImpl(XQueryTestView.java:1866) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.access$300(XQueryTestView.java:174) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent$3.run(XQueryTestView.java:1594) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelectedBusy(XQueryTestView.java:1597) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelected(XQueryTestView.java:1560) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3687) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3298) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) at org.eclipse.equinox.launcher.Main.eclipse_main(Main.java:1148) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.m7.installer.util.NitroxMain$1.run(NitroxMain.java:33) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:199) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160) at java.awt.EventDispatchThread.run(EventDispatchThread.java:121) Caused by: weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_447b134168421dc5:564de77e:12775210007:-7ff2): 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 'PAG_TES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored at com.bea.ld.server.update.recovery.SagaRecovery.process(SagaRecovery.java:104) at com.bea.ld.server.update.recovery.DSPSagaManager.processSagaFailure(DSPSagaManager.java:222) at weblogic.xml.query.update.recovery.SagaState$2.afterCompletion(SagaState.java:87) at weblogic.xml.query.transaction.TransactionManager.afterCompletion(TransactionManager.java:134) at weblogic.transaction.internal.ServerSCInfo.doAfterCompletion(ServerSCInfo.java:1032) at weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:1011) at weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(ServerTransactionImpl.java:2990) at weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:2871) at weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:2847) at weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3087) at weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:2837) at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:400) at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:378) at weblogic.xml.query.transaction.TransactionHelper.rollback(TransactionHelper.java:102) at weblogic.xml.query.transaction.TransactionManager.teardownOnFailure(TransactionManager.java:264) at com.bea.ld.EJBRequestHandler.handleThrowable(EJBRequestHandler.java:829) at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:326) at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84) at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:72) at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589) at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(Unknown Source) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473) at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at weblogic.work.ExecuteThread.run(ExecuteThread.java:173) Caused by: 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 'PAG_TES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored at com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException.create(RDBWrapperException.java:89) at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:127) at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:175) at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:162) at com.bea.dsp.wrappers.rdb.runtime.ProcedureCallableWrapper.executeQuery(ProcedureCallableWrapper.java:426) at com.bea.dsp.wrappers.rdb.runtime.ProcedureIterator.getNextToken(ProcedureIterator.java:195) at com.bea.dsp.wrappers.rdb.runtime.ProcedureIterator.fetchNext(ProcedureIterator.java:125) at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:104) at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:88) at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:104) at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:368) at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:429) at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:271) at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:108) at weblogic.xml.query.update.rewriting.UVMUtils$3.run(UVMUtils.java:130) at weblogic.xml.query.update.recovery.SagaInterpreter.run(SagaInterpreter.java:41) at weblogic.xml.query.update.runtime.UVMRewritingEvaluatorImpl.run(UVMRewritingEvaluatorImpl.java:32) at weblogic.xml.query.xdbcimpl.XQSEStatementImpl.execute(XQSEStatementImpl.java:103) at com.bea.ld.server.XQueryInvocation.execute(XQueryInvocation.java:752) at com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:624) at com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:478) at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:323) ... 12 more Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PAG_TES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source) at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source) at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source) at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source) at weblogic.jdbc.base.BaseStatement.executeInternal(Unknown Source) at weblogic.jdbc.base.BasePreparedStatement.execute(Unknown Source) at weblogic.jdbcx.base.BasePreparedStatementWrapper.execute(Unknown Source) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98) at com.bea.dsp.wrappers.rdb.runtime.ProcedureCallableWrapper.executeQuery(ProcedureCallableWrapper.java:408) ... 29 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago