java.sql.SQLSyntaxErrorException: ORA-01702: a view is not appropriate here

squirrel-sql | eladner | 8 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Error viewing table indexes on Oracle DB

    squirrel-sql | 8 months ago | eladner
    java.sql.SQLSyntaxErrorException: ORA-01702: a view is not appropriate here

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-01702: a view is not appropriate here

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleDatabaseMetaData.getIndexInfo
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
      8. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
      9. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)
      10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
      11. oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1707)
      12. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1670)
      13. oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:310)
      14. oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:4882)
      14 frames
    3. org.squirrelsql.session
      TreeDetailsTabController.lambda$new$1
      1. org.squirrelsql.session.objecttree.TableDetailsReader.lambda$readIndexes$4(TableDetailsReader.java:87)
      2. org.squirrelsql.session.objecttree.TableDetailsReader._loadTableMetaData(TableDetailsReader.java:123)
      3. org.squirrelsql.session.objecttree.TableDetailsReader.loadTableMetaData(TableDetailsReader.java:112)
      4. org.squirrelsql.session.objecttree.TableDetailsReader.readIndexes(TableDetailsReader.java:87)
      5. org.squirrelsql.session.objecttree.TreeDetailsController.lambda$onTreeNodeSelected$12(TreeDetailsController.java:59)
      6. org.squirrelsql.session.objecttree.TreeDetailsTabController.onSelected(TreeDetailsTabController.java:27)
      7. org.squirrelsql.session.objecttree.TreeDetailsTabController.lambda$new$1(TreeDetailsTabController.java:20)
      7 frames
    4. com.sun.javafx
      EventUtil.fireEvent
      1. com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
      2. com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
      3. com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
      4. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
      5. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      6. com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
      7. com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
      7 frames
    5. javafx.event
      Event.fireEvent
      1. javafx.event.Event.fireEvent(Event.java:198)
      1 frame
    6. FXSampler
      Tab$1.invalidated
      1. javafx.scene.control.Tab$1.invalidated(Tab.java:209)
      1 frame
    7. javafx.beans.property
      BooleanPropertyBase.set
      1. javafx.beans.property.BooleanPropertyBase.markInvalid(BooleanPropertyBase.java:109)
      2. javafx.beans.property.BooleanPropertyBase.set(BooleanPropertyBase.java:144)
      2 frames
    8. FXSampler
      TabPane$TabPaneSelectionModel.select
      1. javafx.scene.control.Tab.setSelected(Tab.java:185)
      2. javafx.scene.control.TabPane$TabPaneSelectionModel.select(TabPane.java:722)
      3. javafx.scene.control.TabPane$TabPaneSelectionModel.select(TabPane.java:735)
      4. javafx.scene.control.TabPane$TabPaneSelectionModel.select(TabPane.java:656)
      4 frames
    9. com.sun.javafx
      TabPaneBehavior.selectTab
      1. com.sun.javafx.scene.control.behavior.TabPaneBehavior.selectTab(TabPaneBehavior.java:122)
      1 frame
    10. FXSampler
      TabPaneSkin$TabHeaderSkin$5.handle
      1. com.sun.javafx.scene.control.skin.TabPaneSkin$TabHeaderSkin$5.handle(TabPaneSkin.java:1332)
      2. com.sun.javafx.scene.control.skin.TabPaneSkin$TabHeaderSkin$5.handle(TabPaneSkin.java:1317)
      2 frames
    11. com.sun.javafx
      EventUtil.fireEvent
      1. com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
      2. com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
      3. com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
      4. com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
      5. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
      6. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      7. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      8. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      9. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      10. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      11. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      12. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      13. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      14. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      15. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      16. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      17. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      18. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      19. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      20. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      21. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      22. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      23. com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
      24. com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
      25. com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
      26. com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
      26 frames
    12. javafx.event
      Event.fireEvent
      1. javafx.event.Event.fireEvent(Event.java:198)
      1 frame
    13. javafx.scene
      Scene$ScenePeerListener.mouseEvent
      1. javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
      2. javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
      3. javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
      4. javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
      4 frames
    14. com.sun.javafx
      GlassViewEventHandler$MouseEventNotification.run
      1. com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:380)
      2. com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:294)
      2 frames
    15. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    16. com.sun.javafx
      GlassViewEventHandler.handleMouseEvent
      1. com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$354(GlassViewEventHandler.java:416)
      2. com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
      3. com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:415)
      3 frames
    17. com.sun.glass
      GtkApplication.lambda$null$49
      1. com.sun.glass.ui.View.handleMouseEvent(View.java:555)
      2. com.sun.glass.ui.View.notifyMouse(View.java:937)
      3. com.sun.glass.ui.gtk.GtkApplication._runLoop(Native Method)
      4. com.sun.glass.ui.gtk.GtkApplication.lambda$null$49(GtkApplication.java:139)
      4 frames
    18. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame