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

Oracle Community | 761210 | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Problem creating physical service using stored procedure.

    Oracle Community | 7 years ago | 761210
    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
  2. 0

    java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01830: date fo

    Oracle Community | 8 years ago | 701870
    com.bea.dsp.das.exception.DASException: com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {ld:ViewFolder/physical/VIEW}VIEW:0, line 4, column 1:{bea-err}RDBW0004: [Database]: [SELECT t3.c1, t3.c2, t3.c3 FROM ( SELECT ROWNUM AS c4, t2.c1, t2.c2, t2.c3 FROM ( SELECT t1."DATE" AS c1, t1."ID" AS c2, t1."FK_ID" AS c3 FROM "SCHEMA"."VIEW" t1 ) t2 WHERE (ROWNUM < 501) ) t3]: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string
  3. 0

    oracle stored procedure with an inout boolean parameter

    Oracle Community | 1 decade ago | 666705
    java.lang.RuntimeException: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'P_GET_LIST_OF_ADDRESSES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid Number Error

    Google Groups | 1 decade ago | Tahir Emre KALAYCI
    java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01722: invalid number
  6. 0

    P13/Profile data sharing between two WLP instance

    Oracle Community | 7 years ago | 732657
    java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (WLP_USER2.PK_ENT_POLICY) violated

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. weblogic.jdbc.base
      BaseExceptions.getException
      1. weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
      2. weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
      2 frames
    3. weblogic.jdbc.oracle
      OracleImplStatement.execute
      1. weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
      1 frame
    4. weblogic.jdbc.base
      BasePreparedStatement.execute
      1. weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
      2. weblogic.jdbc.base.BaseStatement.executeInternal(Unknown Source)
      3. weblogic.jdbc.base.BasePreparedStatement.execute(Unknown Source)
      3 frames
    5. weblogic.jdbcx.base
      BasePreparedStatementWrapper.execute
      1. weblogic.jdbcx.base.BasePreparedStatementWrapper.execute(Unknown Source)
      1 frame
    6. weblogic.jdbc.wrapper
      PreparedStatement.execute
      1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
      1 frame
    7. com.bea.dsp
      ProcedureIterator.fetchNext
      1. com.bea.dsp.wrappers.rdb.runtime.ProcedureCallableWrapper.executeQuery(ProcedureCallableWrapper.java:408)
      2. com.bea.dsp.wrappers.rdb.runtime.ProcedureIterator.getNextToken(ProcedureIterator.java:195)
      3. com.bea.dsp.wrappers.rdb.runtime.ProcedureIterator.fetchNext(ProcedureIterator.java:125)
      3 frames
    8. weblogic.xml.query
      XQSEStatementImpl.execute
      1. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:104)
      2. weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:88)
      3. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:104)
      4. weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:368)
      5. weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:429)
      6. weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:271)
      7. weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:108)
      8. weblogic.xml.query.update.rewriting.UVMUtils$3.run(UVMUtils.java:130)
      9. weblogic.xml.query.update.recovery.SagaInterpreter.run(SagaInterpreter.java:41)
      10. weblogic.xml.query.update.runtime.UVMRewritingEvaluatorImpl.run(UVMRewritingEvaluatorImpl.java:32)
      11. weblogic.xml.query.xdbcimpl.XQSEStatementImpl.execute(XQSEStatementImpl.java:103)
      11 frames
    9. com.bea.ld
      Server_ydm4ie_EOImpl_WLSkel.invoke
      1. com.bea.ld.server.XQueryInvocation.execute(XQueryInvocation.java:752)
      2. com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:624)
      3. com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:478)
      4. com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:323)
      5. com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)
      6. com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:72)
      7. com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)
      7 frames
    10. weblogic.rmi.internal
      BasicServerRef.invoke
      1. weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
      1 frame
    11. weblogic.rmi.cluster
      ClusterableServerRef.invoke
      1. weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
      1 frame
    12. weblogic.rmi.internal
      BasicServerRef$1.run
      1. weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
      1 frame
    13. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      1 frame
    14. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(Unknown Source)
      1 frame
    15. weblogic.rmi.internal
      WLSExecuteRequest.run
      1. weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
      2. weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
      2 frames
    16. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      2 frames