4 Replies Latest reply on Jul 8, 2020 6:55 AM by Peter2_1

    [19.4] java.lang.StackOverflowError ...at oracle.dbtools.parser.Earley.tree

    Peter2_1

      Maybe connected with posting [19.4] Missing line-number in long SQLstatements  ??

      ----------------------------

      I have a file called "test.sql" which looks like this

       

      WITH MOCK_TAB (MOC_VON, MOC_NACH, MOC_ZUS) AS (
      select '101.0','102.0','A0' from dual
      union all
      select '101.1','101.0','A0' from dual
      union all
      select '101.2','160.07*','A0' from dual
      union all
      select '102.0','102.1','A0' from dual
      ...
      .. repeat both lines with different content approx. 900 times
      ---
      union all
      select 'PW6','200.0','A0' from dual
      union all
      select 'PW7','200.10','A0' from dual
      )
      select * from mock_tab
      
      

       

      - I close SQL dev with this file (worksheet) opened

      - I start SQL DEV again (from Win 10), it opens the SQL files by itself, and in CMD-window I get this message:

      java.lang.StackOverflowError
              at oracle.dbtools.util.Array.indexOf(Array.java:81)
              at oracle.dbtools.util.Array.indexOf(Array.java:83)
              at oracle.dbtools.util.Array.indexOf(Array.java:83)
              at oracle.dbtools.util.Array.indexOf(Array.java:81)
              at oracle.dbtools.util.Array.indexOf(Array.java:81)
              at oracle.dbtools.util.Array.indexOf(Array.java:83)
              at oracle.dbtools.util.Array.indexOf(Array.java:56)
              at oracle.dbtools.parser.Earley.followComplete(Earley.java:787)
              at oracle.dbtools.parser.Earley.tree(Earley.java:735)
      ...
      ... repeat both lines approx. 500 times
      ...
              at oracle.dbtools.parser.Earley.tree(Earley.java:735)
              at oracle.dbtools.parser.Earley.followComplete(Earley.java:806)
      
      

       

      - When I close and start SQL dev. without the connected SQL-file, then the CMD-windows stays completely empty.

       

      Usual behaviour or something what I have to consider?