java.sql.SQLException: Fail to convert to internal representation

Oracle Community | TAJDIN | 5 months ago
  1. 0

    Not able to call Stored procedure contains Varchar2_table as a parameter from Java

    Stack Overflow | 2 years ago | Jigyasu
    java.sql.SQLException: Fail to convert to internal representation:
  2. 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()
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    jroller.com | 2 months ago
    org.hibernate.exception.GenericJDBCException: could not load an entity: [qc.nerf.provision.model.WirelessAccessory#d88a139]
  5. 0

    Pass array as input parameter to an oracle stored procedure using simple jdbc call

    Stack Overflow | 2 years ago | Abhishek Singh
    java.sql.SQLException: Fail to convert to internal representation: TMFI10000031A

    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

      Fail to convert to internal representation

      at oracle.jdbc.driver.CharCommonAccessor.getBigDecimal()
    2. Oracle jdbc
      GeneratedScrollableResultSet.getBigDecimal
      1. oracle.jdbc.driver.CharCommonAccessor.getBigDecimal(CharCommonAccessor.java:392)
      2. oracle.jdbc.driver.GeneratedStatement.getBigDecimal(GeneratedStatement.java:99)
      3. oracle.jdbc.driver.GeneratedScrollableResultSet.getBigDecimal(GeneratedScrollableResultSet.java:219)
      3 frames
    3. oracle.jbo.common
      BigDecimalTypeSQLNativeImpl.getDataFromResultSet
      1. oracle.jbo.common.BigDecimalTypeSQLNativeImpl.getDataFromResultSet(JboTypeMapEntries.java:974)
      1 frame
    4. oracle.jbo.server
      AttributeDefImpl.loadFromResultSet
      1. oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:2928)
      1 frame