Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

19.4 Procedure Conditional Formatting

LeeG-BBYJan 31 2020 — edited Feb 5 2020

In 19.1, I was able to conditionally format procedures that used named notation to use line breaks, but procedures that did not use named notation to not use line breaks with a fix provided in this thread https://community.oracle.com/thread/4270289

I re-applied the fix to 19.4, but it does not work like it used to in 19.1.

Current formatting settings:

pastedImage_0.png

Formatting results BEFORE applying fix:

BEGIN

-- With named notation

proc1(

param\_1  => val\_1

, param_2 => val_2

, param_3 => val_3

);

-- Without named notation

proc1(

param\_1

, param_2

, param_3

);

END;

Formatting results AFTER applying fix:

BEGIN

-- With named notation

proc1(

param\_1  => val\_1

, param_2 => val_2

, param_3 => val_3

);

-- Without named notation

proc1(param_1

  , param\_2

  , param\_3);

END;

Expected results:

BEGIN

-- With named notation

proc1(

param\_1  => val\_1

, param_2 => val_2

, param_3 => val_3

);

-- Without named notation

proc1(param_1, param_2, param_3);

END;

Is there a way to get this to work again in 19.4?

Thanks,

Lee

This post has been answered by Vadim Tropashko-Oracle on Jan 31 2020
Jump to Answer
Comments
Post Details
Added on Jan 31 2020
6 comments
285 views