1 Reply Latest reply on Aug 27, 2020 4:05 PM by Vadim Tropashko-Oracle

    return is not uppercased as keyword with formater

    Richard Wiener

      Hi,

      After formating:

      BEGIN

          return;

      END;

      /

       

      I think thant RETURN is a keyword and should be uppercased.

      Thank for fix.

        • 1. Re: return is not uppercased as keyword with formater
          Vadim Tropashko-Oracle

          This is parse bug:

           

          [0,6)  sql_statement  sql_statements

            [0,5)  block_stmt  labeled_block_stmt  library_unit

              [0,1)  'BEGIN'

              [1,3)  labeled_nonblock_stmt  seq_of_stmts  sim_stmt  stmt  unlabeled_nonblock_stmt

                [1,2)  identifier  name  name_wo_function_call  procedure_call

                [2,3)  ';'

              [3,4)  'END'

              [4,5)  ';'

            [5,6)  '/'

           

          The Custom Format workaround:

          ...

          "analytics":

              [identifier) identifier

            & [call) analytic_function

            & [call = [identifier

          ;

          "ids": --node) <= [node + 1

             [identifier) identifier

             & ! ?identifier = 'return'

          ;

          identifiers: "ids" - "analytics"

          ->

          ;

          ...