Menu

#422 Fails to export oracle schema, is generating invalid sql

v2.6.*
pending
None
(not fixed)
5
2019-02-02
2019-01-31
JIm Schmidt
No

Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)
at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:110)
at org.dbunit.database.ForwardOnlyResultSetTable.<init>(ForwardOnlyResultSetTable.java:59)
at org.dbunit.database.CachedResultSetTableFactory.createTable(CachedResultSetTableFactory.java:60)
at org.dbunit.database.DatabaseDataSet.getTable(DatabaseDataSet.java:319)
... 5 more

Caused by: Error : 936, Position : 98, Sql = select COORD_SYS_ID, COORD_AXIS_NAME_ID, COORD_AXIS_ORIENTATION, COORD_AXIS_ABBREVIATION, UOM_ID, ORDER from SDO_COORD_AXES order by COORD_SYS_ID, ORDER, OriginalSql = select COORD_SYS_ID, COORD_AXIS_NAME_ID, COORD_AXIS_ORIENTATION, COORD_AXIS_ABBREVIATION, UOM_ID, ORDER from SDO_COORD_AXES order by COORD_SYS_ID, ORDER, Error Msg = ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 21 more

Discussion

  • Jeff Jensen

    Jeff Jensen - 2019-02-02
    • status: open --> pending
    • assigned_to: Jeff Jensen
     
  • Jeff Jensen

    Jeff Jensen - 2019-02-02

    Do you have time to create a reproducing test please (and a fix too)?

     

Log in to post a comment.