Formatting time increases exponentially

SQL Navigator
1

**SQL Navigator 6.2.0.1500
Formatting time increases exponentially along with number of parameters in function.

Try to format following package:**

CREATE OR REPLACE
PACKAGE test_pkg
AS
FUNCTION test_funct
(
pi_1 IN PLS_INTEGER DEFAULT NULL,
pi_2 IN PLS_INTEGER,
pi_3 IN PLS_INTEGER)
RETURN INTEGER RESULT_CACHE;
END test_pkg;
/

Everything seems ok but try to add more parameters to function.
Every one additional parameter formatting time increases dramatically.
Formatting package like this one:

CREATE OR REPLACE
PACKAGE test_pkg
AS
FUNCTION test_funct
(
pi_1 IN PLS_INTEGER DEFAULT NULL,
pi_2 IN PLS_INTEGER,
pi_3 IN PLS_INTEGER,
pi_4 IN PLS_INTEGER DEFAULT NULL,
pi_5 IN PLS_INTEGER DEFAULT NULL,
pi_6 IN PLS_INTEGER DEFAULT NULL,
pi_7 IN PLS_INTEGER DEFAULT NULL,
pi_8 IN PLS_INTEGER DEFAULT NULL,
pi_9 IN PLS_INTEGER DEFAULT NULL,
pi_10 IN PLS_INTEGER DEFAULT NULL,
pi_11 IN PLS_INTEGER DEFAULT NULL,
pi_12 IN PLS_INTEGER DEFAULT NULL,
pi_13 IN PLS_INTEGER DEFAULT NULL,
pi_14 IN PLS_INTEGER DEFAULT NULL,
pi_15 IN PLS_INTEGER DEFAULT NULL,
pi_16 IN PLS_INTEGER DEFAULT NULL,
pi_17 IN PLS_INTEGER DEFAULT NULL,
pi_18 IN PLS_INTEGER DEFAULT NULL,
pi_19 IN PLS_INTEGER DEFAULT NULL,
pi_20 IN PLS_INTEGER DEFAULT NULL,
pi_21 IN PLS_INTEGER DEFAULT NULL,
pi_22 IN PLS_INTEGER DEFAULT NULL,
pi_23 IN PLS_INTEGER DEFAULT NULL,
pv_24 IN VARCHAR2 DEFAULT NULL,
pi_25 IN INTEGER,
pi_26 IN PLS_INTEGER DEFAULT NULL,
pbol_27 IN BOOLEAN DEFAULT NULL,
pv_28 IN VARCHAR2 DEFAULT ‘ALL’)
RETURN INTEGER RESULT_CACHE;
END test_pkg;
/

hangs SQL Navigator.

Message was edited by: fordmtonly_656

2

Hi,
I couldn’t reproduce the issue with the scripts that you provided. May I get the formatter options file from you? The formatter options file is stored in C:\Documents and Settings<user>\Application Data\Quest Software\SQL Navigator 6.2.0. Please get a copy of the FmtOptions.opt file and attach it when you reply.

As a workaround for you before we figure out the problem, please try to delete the FmtOptions.opt and format your script again. Let me know if this works for you. Please get a copy of the FmtOptions.opt file and attach it, no matter the workaround works or not. So that we can investigate the issue.

Thanks,
Vincent

3

Hi,
I managed to reproduce the issue. It happens with the Parameter Declarations settings in formatter options. If the list arrangement style is set to an option of Wrapped or Table, the formatter cannot handle it then SQL Navigator hangs. I will raise CR for the formatter team to fix this as soon as possible.

At the moment, you can select the list arrangment style to “Stack on more than…” or “Stack on Overflow or More than…” then the issue will not happen. You can find the option page from Tools | Formatter Tools | Formatting Options, then select the Parameter Declaration page as shown in the image.

Thanks for pointing this out. Please try changing this option to see if it works for you. If it works, you don’t need to attach the opt file and you don’t need to delete the file either :slight_smile:

Thanks,
Vincent
Para_Style.jpeg

4

thx that helped