java.sql.SQLSyntaxErrorException: ORA-01791: not a SELECTed expression

Oracle Community | 793445 | 6 years ago
  1. 0

    Suppress Dublicate Rows in Table in RTF

    Oracle Community | 6 years ago | 793445
    java.sql.SQLSyntaxErrorException: ORA-01791: not a SELECTed expression
  2. 0

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

    Oracle Community | 3 years ago | user13100220
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  3. 0

    Problem in Data Template ORA-00911: invalid character

    Oracle Community | 7 years ago | 665465
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    XML PUBLISHER/XDO ERROR  - Output file was found but is zero sized - Delete

    Oracle Community | 6 years ago | user564732-Oracle
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  6. 0

    Error in Report Using XMLP without report builder

    Oracle Community | 4 years ago | Uva
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

  1. rafafviola 1 times, last 1 month ago
  2. wendellpereira 128 times, last 2 months ago
  3. balintn 4 times, last 2 months ago
  4. balintn 3 times, last 3 months ago
  5. pnaranja 2 times, last 4 months ago
1 more registered users
30 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.SQLSyntaxErrorException

    ORA-01791: not a SELECTed expression

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1189)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 frames
  3. oracle.apps.xdo
    JCP4XDODataEngine.runProgram
    1. oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947)
    2. oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501)
    3. oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)
    4. oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)
    5. oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)
    6. oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
    7. oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
    8. oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
    9. oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
    10. oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
    11. oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
    11 frames
  4. oracle.apps.fnd
    Run.main
    1. oracle.apps.fnd.cp.request.Run.main(Run.java:157)
    1 frame