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

Oracle Community | 666705 | 1 decade ago
  1. 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
  2. 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
  3. 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
  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 'P_GET_LIST_OF_ADDRESSES' 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.jdbc.wrapper
      PreparedStatement.execute
      1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:102)
      1 frame
    6. com.bea.ld
      ProcedureIterator.fetchNext
      1. com.bea.ld.wrappers.procedure.ProcedureAdapter$CallableWrapper.executeQuery(ProcedureAdapter.java:569)
      2. com.bea.ld.wrappers.procedure.ProcedureIterator.getNextToken(ProcedureIterator.java:205)
      3. com.bea.ld.wrappers.procedure.ProcedureIterator.fetchNext(ProcedureIterator.java:127)
      3 frames
    7. weblogic.xml.query
      Serializer.serializeItems
      1. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:113)
      2. weblogic.xml.query.xdbc.iterators.ItemIterator.fetchNext(ItemIterator.java:85)
      3. weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:134)
      4. weblogic.xml.query.runtime.sequences.Subsequence.fetchNext(Subsequence.java:101)
      5. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:113)
      6. weblogic.xml.query.runtime.querycide.QueryAssassin.fetchNext(QueryAssassin.java:54)
      7. weblogic.xml.query.iterators.GenericIterator.peekNext(GenericIterator.java:151)
      8. weblogic.xml.query.runtime.qname.InsertNamespaces.fetchNext(InsertNamespaces.java:232)
      9. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:113)
      10. weblogic.xml.query.runtime.core.QueryIterator.fetchNext(QueryIterator.java:124)
      11. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:113)
      12. weblogic.xml.query.xdbc.iterators.ItemIterator.fetchNext(ItemIterator.java:85)
      13. weblogic.xml.query.iterators.GenericIterator.peekNext(GenericIterator.java:151)
      14. weblogic.xml.query.xdbc.util.Serializer.processNamespaces(Serializer.java:303)
      15. weblogic.xml.query.xdbc.util.Serializer.processElement(Serializer.java:233)
      16. weblogic.xml.query.xdbc.util.Serializer.process(Serializer.java:187)
      17. weblogic.xml.query.xdbc.util.Serializer.serializeItems(Serializer.java:133)
      17 frames
    8. com.bea.ld
      Server_ydm4ie_EOImpl_WLSkel.invoke
      1. com.bea.ld.server.QueryInvocation.getResult(QueryInvocation.java:461)
      2. com.bea.ld.EJBRequestHandler.executeFunction(EJBRequestHandler.java:346)
      3. com.bea.ld.ServerBean.executeFunction(ServerBean.java:108)
      4. com.bea.ld.Server_ydm4ie_EOImpl.executeFunction(Server_ydm4ie_EOImpl.java:586)
      5. com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)
      5 frames
    9. weblogic.rmi.internal
      BasicServerRef.invoke
      1. weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:492)
      1 frame
    10. weblogic.rmi.cluster
      ReplicaAwareServerRef.invoke
      1. weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:108)
      1 frame
    11. weblogic.rmi.internal
      BasicServerRef$1.run
      1. weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:435)
      1 frame
    12. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      1 frame
    13. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
      1 frame
    14. weblogic.rmi.internal
      BasicExecuteRequest.execute
      1. weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:430)
      2. weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:35)
      2 frames
    15. weblogic.kernel
      ExecuteThread.run
      1. weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
      2. weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
      2 frames