java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

Oracle Community | 958846 | 4 years ago
  1. 0

    java.sql.SQLException: ORA-01403: no data found

    Oracle Community | 4 years ago | 958846
    java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  2. 0

    Fail to convert to internal representation in Store procedure

    Stack Overflow | 2 years ago
    java.sql.SQLException: Fail to convert to internal representation: Blindingtpe
  3. 0

    Java Oracle oracle.sql.ARRAY error

    Stack Overflow | 3 years ago
    java.sql.SQLException: Fail to convert to internal representation: javax.sql.rowset.serial.SerialBlob@d316ee
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Eclipse Community Forums: EclipseLink ยป PLSQLStoredProcedureCall Fail to convert to internal representation

    eclipse.org | 1 year ago
    java.sql.SQLException: Fail to convert to internal representation: Error Code: 17059 Call: DECLARE P_RECORDS_TARGET HR_DEPARTMENTS.DEPTTABTYPE; P_RECORDS_COMPAT HR_DEPARTMENT_TYPE := :1; FUNCTION EL_SQL2PL_1(aSqlItem HR_DEPARTMENT_ROW_TYPE) RETURN HR_DEPARTMENTS.DEPARTMENTRECTYPE IS aPlsqlItem HR_DEPARTMENTS.DEPARTMENTRECTYPE; BEGIN aPlsqlItem.DEPARTMENT_ID := aSqlItem.DEPARTMENT_ID; aPlsqlItem.DEPARTMENT_NAME := aSqlItem.DEPARTMENT_NAME; aPlsqlItem.LOCATION_ID := aSqlItem.LOCATION_ID; aPlsqlItem.MANAGER_ID := aSqlItem.MANAGER_ID; RETURN aPlsqlItem; END EL_SQL2PL_1; FUNCTION EL_SQL2PL_3(aSqlItem HR_DEPARTMENT_TYPE) RETURN HR_DEPARTMENTS.DEPTTABTYPE IS aPlsqlItem HR_DEPARTMENTS.DEPTTABTYPE; BEGIN IF aSqlItem.COUNT > 0 THEN FOR I IN 1..aSqlItem.COUNT LOOP aPlsqlItem(I) := EL_SQL2PL_1(aSqlItem(I)); END LOOP; END IF; RETURN aPlsqlItem; END EL_SQL2PL_3; BEGIN P_RECORDS_TARGET := EL_SQL2PL_3(P_RECORDS_COMPAT); HR_DEPARTMENTS.INSERTDEPARTMENTS(P_RECORDS=>P_RECORDS_TARGET); END; bind => [:1 => [ , ]] Query: DataReadQuery()
  6. 0

    Re: Helping developers write a pl/sql wrapper to translate a nested table to jdbc VARRAY - oracle-l - FreeLists

    freelists.org | 1 year ago
    java.sql.SQLException: Fail to convert to internal representation: 88659

    2 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

      ORA-01403: no data found ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      ARRAY.<init>
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      2. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
      7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
      8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
      9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
      11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4693)
      12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
      13. oracle.jdbc.oracore.OracleTypeCOLLECTION.initCollElemTypeName(OracleTypeCOLLECTION.java:833)
      14. oracle.jdbc.oracore.OracleTypeCOLLECTION.getAttributeType(OracleTypeCOLLECTION.java:905)
      15. oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:81)
      16. oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:68)
      17. oracle.sql.TypeDescriptor.initSQLName(TypeDescriptor.java:747)
      18. oracle.sql.TypeDescriptor.getTypeName(TypeDescriptor.java:808)
      19. oracle.sql.StructDescriptor.initMetaData1_9_0(StructDescriptor.java:1441)
      20. oracle.sql.StructDescriptor.initMetaData1(StructDescriptor.java:1326)
      21. oracle.sql.StructDescriptor.isInstantiable(StructDescriptor.java:871)
      22. oracle.sql.STRUCT.<init>(STRUCT.java:152)
      23. oracle.jdbc.oracore.OracleTypeADT.createObjSTRUCT(OracleTypeADT.java:2248)
      24. oracle.jdbc.oracore.OracleTypeADT.toDatum(OracleTypeADT.java:333)
      25. oracle.jdbc.oracore.OracleTypeADT.toDatumArray(OracleTypeADT.java:372)
      26. oracle.jdbc.oracore.OracleTypeUPT.toDatumArray(OracleTypeUPT.java:110)
      27. oracle.sql.ArrayDescriptor.toOracleArray(ArrayDescriptor.java:1238)
      28. oracle.sql.ARRAY.<init>(ARRAY.java:103)
      28 frames