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

squirrel-sql | eladner | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error viewing table indexes on Oracle DB

    squirrel-sql | 7 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