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

Oracle Community | 668229 | 8 years ago
  1. 0

    Problems using XML DB with Schema

    Oracle Community | 8 years ago | 668229
    java.sql.SQLException: Fail to convert to internal representation
  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

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

      at oracle.jdbc.driver.SQLStateMapping.newSQLException()
    2. Oracle jdbc
      OPAQUE.<init>
      1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
      2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
      3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
      4. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
      5. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
      6. oracle.sql.OPAQUE.<init>(OPAQUE.java:85)
      6 frames
    3. oracle.xdb
      XMLType.toDatum
      1. oracle.xdb.XMLType.toDatum(XMLType.java:492)
      1 frame
    4. Oracle jdbc
      OraclePreparedStatementWrapper.setObject
      1. oracle.jdbc.driver.OraclePreparedStatement.setORADataInternal(OraclePreparedStatement.java:7437)
      2. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8158)
      3. oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8149)
      4. oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:229)
      4 frames
    5. weblogic.jdbc.wrapper
      PreparedStatement.setObject
      1. weblogic.jdbc.wrapper.PreparedStatement.setObject(PreparedStatement.java:314)
      1 frame
    6. org.foo.test
      Test.testAddObjectHandle
      1. org.foo.test.Test.doInsert(Test.java:76)
      2. org.foo.test.Test.testAddObjectHandle(Test.java:32)
      2 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    8. weblogic.wsee.component
      JavaClassComponent.invoke
      1. weblogic.wsee.component.pojo.JavaClassComponent.invoke(JavaClassComponent.java:112)
      1 frame
    9. weblogic.wsee.ws
      ComponentHandler.handleRequest
      1. weblogic.wsee.ws.dispatch.server.ComponentHandler.handleRequest(ComponentHandler.java:84)
      1 frame
    10. weblogic.wsee.handler
      HandlerIterator.handleRequest
      1. weblogic.wsee.handler.HandlerIterator.handleRequest(HandlerIterator.java:141)
      1 frame
    11. weblogic.wsee.ws
      WsSkel.invoke
      1. weblogic.wsee.ws.dispatch.server.ServerDispatcher.dispatch(ServerDispatcher.java:114)
      2. weblogic.wsee.ws.WsSkel.invoke(WsSkel.java:80)
      2 frames
    12. weblogic.wsee.server
      BaseWSServlet.service
      1. weblogic.wsee.server.servlet.SoapProcessor.handlePost(SoapProcessor.java:66)
      2. weblogic.wsee.server.servlet.SoapProcessor.process(SoapProcessor.java:44)
      3. weblogic.wsee.server.servlet.BaseWSServlet$AuthorizedInvoke.run(BaseWSServlet.java:285)
      4. weblogic.wsee.server.servlet.BaseWSServlet.service(BaseWSServlet.java:169)
      4 frames
    13. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      1 frame
    14. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
      4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
      5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
      5 frames
    15. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    16. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(Unknown Source)
      1 frame
    17. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
      3 frames
    18. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      2 frames