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
  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 | 7 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