Code Formatter Adding Extra Blank Lines After Comments (12.8.0.19)

Toad for Oracle - Beta
1

In the Toad for Oracle 12.8.0.19 beta, the Toad Code Formatter is adding 2 blank lines in the source code after multiline PLSQL comment blocks enclosed inside of /* */ delimiters.

This is a new behavior that does not happen in Toad 12.7 or earlier.

EXAMPLE:

CODE INSIDE OF PLSQL PACKAGE BEFORE FORMATTING:

/*
Function Name: c_adty_id_mailing CONSTANT
Purpose: Defines the value of APP_ENV server variable on the DEVELOPMENT Oracle Application Server

 Parameters:     none

 Returns:        This function returns the same VARCHAR2 value in all environments.

 Procedure Modification History
 ----------------------------
 Date        By    Req/Prob#   Env/Date         Description
 ----------  ----  ----------- ---------------  ----------------------------------------------------
 05/26/2011  JAR                                Create function

*/
FUNCTION c_adty_id_mailing
RETURN VARCHAR2
IS
l_adty_id_mailing NUMBER(12);
BEGIN
SELECT addr_type_id
INTO l_adty_id_mailing
FROM CORP_COMMON2.ADDR_TYPE a
WHERE a.type_code = ‘ADDR_MAILING’;

  RETURN l_adty_id_mailing;

END c_adty_id_mailing;

CODE INSIDE OF PLSQL PACKAGE AFTER FORMATTING:

/*
Function Name: c_adty_id_mailing CONSTANT
Purpose: Defines the value of APP_ENV server variable on the DEVELOPMENT Oracle Application Server

 Parameters:     none

 Returns:        This function returns the same VARCHAR2 value in all environments.

 Procedure Modification History
 ----------------------------
 Date        By    Req/Prob#   Env/Date         Description
 ----------  ----  ----------- ---------------  ----------------------------------------------------
 05/26/2011  JAR                                Create function

*/

FUNCTION c_adty_id_mailing
RETURN VARCHAR2
IS
l_adty_id_mailing NUMBER(12);
BEGIN
SELECT addr_type_id
INTO l_adty_id_mailing
FROM CORP_COMMON2.ADDR_TYPE a
WHERE a.type_code = ‘ADDR_MAILING’;

  RETURN l_adty_id_mailing;

END c_adty_id_mailing;
Toad_Code_Formatter_Blank_Lines.zip (2.15 KB)

2

This is a regression. Nice catch, thanks!

QP5.dll version 5.280 (May 18) was the last version where it still worked fine.

I fixed it for the upcoming version 5.288. Expect it in Toad within a few weeks.

Thanks,

Andre