java.sql.SQLException: Fail to convert to internal representation: OPAQUE()

Oracle Community | 4550 | 10 years ago
  1. 0

    error Reading clob and convert xmltype using Java stored procedure.

    Oracle Community | 10 years ago | 4550
    java.sql.SQLException: Fail to convert to internal representation: OPAQUE()
  2. 0

    XDK 10.1.0.2.0 NT XMLType and org.w3c.dom.Document problem/bug?

    Oracle Community | 8 years ago | 663091
    java.sql.SQLException: Fail to convert to internal representation
  3. 0

    Problems using XML DB with Schema

    Oracle Community | 8 years ago | 668229
    java.sql.SQLException: Fail to convert to internal representation
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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:
  6. 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()

    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: OPAQUE()

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OPAQUE.<init>
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
      3. oracle.sql.OPAQUE.<init>(OPAQUE.java:129)
      3 frames
    3. oracle.xdb
      XMLType.toDatum
      1. oracle.xdb.XMLType.toDatum(XMLType.java:544)
      1 frame
    4. Oracle jdbc
      OraclePreparedStatement.setObject
      1. oracle.jdbc.driver.OraclePreparedStatement.setORADataInternal(OraclePreparedStatement.java:10213)
      2. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:11105)
      3. oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:11098)
      3 frames
    5. Unknown
      ArcIns.MsgInsert
      1. ArcIns.MsgInsert(ArcIns.java:31)
      1 frame