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!

[42EA] Formatter bug (maybe)

Patrick JolliffeOct 3 2016 — edited Oct 3 2016

Seems to only add extra line after procedure definition if 5 or more parameters.  Not sure if this is by design, or if this is a bug.

To me it looks inconsistent, I think it should be one or the other always (possibly controlled by preference).

--After formatting

CREATE OR REPLACE PACKAGE sqldev_test AS

   PROCEDURE p1 (

      a   IN VARCHAR2

   );

   PROCEDURE p2 (

      a   IN VARCHAR2,

      b   IN VARCHAR2

   );

   PROCEDURE p3 (

      a   IN VARCHAR2,

      b   IN VARCHAR2,

      c   IN VARCHAR2

   );

   PROCEDURE p4 (

      a   IN VARCHAR2,

      b   IN VARCHAR2,

      c   IN VARCHAR2,

      d   IN VARCHAR2

   );

   PROCEDURE p5 (

      a   IN VARCHAR2,

      b   IN VARCHAR2,

      c   IN VARCHAR2,

      d   IN VARCHAR2,

      e   IN VARCHAR2

   );

   PROCEDURE p6 (

      a   IN VARCHAR2,

      b   IN VARCHAR2,

      c   IN VARCHAR2,

      d   IN VARCHAR2,

      e   IN VARCHAR2,

      f   IN VARCHAR2

   );

END;

/

Comments

Gary Graham-Oracle
Hi,

Please read through the following post from this forum on a similar issue, but related to a driver version mismatch:
10557983

If that does not apply, then the mismatch may be something you can fix by changing some settings -- the following thread provides additional advice and reference links:
10589044

Hope this helps,
Gary
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 31 2016
Added on Oct 3 2016
1 comment
168 views