Block comments in test window are not recognised by "Scan source for variables" button

[Claus Pedersen]

I have created a test script by typing dbms_stats.gather_table_stats in an editor, rightclicking the text and select 'Test'.
A test script is created:

begin
  -- Call the procedure
  sys.dbms_utility.analyze_schema(schema => :schema,
                                  method => :method,
                                  estimate_rows => :estimate_rows,
                                  estimate_percent => :estimate_percent,
                                  method_opt => :method_opt);
end;

The variable list contains the variables: schema, method, estimate_rows, estimate_percent, method_opt

I now modify the test script by removing the parameters with default values by making a block comment (beginning at line 4 and ending at line 7):

begin
  -- Call the procedure
  sys.dbms_utility.analyze_schema(schema => :schema,
                                  method => :method/*,
                                  estimate_rows => :estimate_rows,
                                  estimate_percent => :estimate_percent,
                                  method_opt => :method_opt*/);
end;

I press the "Scan source for variables" button to remove the auxillary variables. Nothing happens. Normally the check boxes for the variables estimate_rows, estimate_percent, method_opt should be cleared.
If I use line comments to remove the variables, it works OK. If I use line comments inside the block comment, it also works OK(!) It seems like the test editor can not interpret the block comments correctly.

Another strange case: testing the procedure sys.dbms_stats.gather_table_stats will create 15 test variables. By removing all PL/SQL variables (in the declare part) and parameters with default values by using block comments, so only the parameters ownname and tabname are remaining, and using the "Scan source for variables" button, only variables block_sample, cascade, no_invalidate, force are cleared (i.e. the variables used in the declare part of the code)

I am using version 8.0.4.1514

 

[Marco Kalter]

This does indeed not work correctly. We'll fix it.

 

[Claus Pedersen]

Thanks