2 Replies Latest reply on Feb 5, 2019 7:56 AM by user11092389

    Seems there is a Bug in Sql Developer 18.4 - Find Database Objects

    user11092389

      I searched for the string 'SCCM' in my Database.

      SQLDevFind.png

      It founds PL/SQL code but no View code. But there is definetly one View containing this string. If i execute the search there is an error message in Logging Page:

       

      ORA-06550: Zeile 2, Spalte 38:

      PLS-00103: Fand das Symbol "SCCM" als eines der folgenden erwartet wurde:

       

       

         * & = - + ; < / > at in is mod remainder not rem

         <an exponent (**)> <> or != or ~= >= <= <> and or like like2

         like4 likec between || multiset member submultiset

      Das Symbol "* wurde vor "SCCM" eingefügt, um fortzufahren.

       

      and the Code executed (from the Stament - Log) is

       

      declare

          l_search     varchar2(1000) := ''SCCM'';

          text         VARCHAR2(32767);

          l_char       VARCHAR2(32767);

          l_rc         SYS_REFCURSOR;

          TYPE strtbl IS

              TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;

       

      As you can see line 2, column 38 is SCCM, and there are 2 ' missing.

       

      This finds the View but no PL/SQL:

      SQLDevFind2.png

       

      Is there a workaround? I need this very often.

       

      I know there is a Bug related to ORDS, but this is not checked.

       

      Regards

      Robert