The alignment of select fileds and procedure's args breaks when setting line breaks before commas and no space after commas:
-- Output
CREATE OR REPLACE PACKAGE BODY emp_mgmt AS
tot_emps NUMBER;
tot_depts NUMBER;
FUNCTION hire(
last_name VARCHAR2
,job_id VARCHAR2
,manager_id NUMBER
,salary NUMBER
,department_id NUMBER
)RETURN NUMBER IS
new_empno NUMBER;
BEGIN
-- Expected
CREATE OR REPLACE PACKAGE BODY emp_mgmt AS
tot_emps NUMBER;
tot_depts NUMBER;
FUNCTION hire(
last_name VARCHAR2
,job_id VARCHAR2
,manager_id NUMBER
,salary NUMBER
,department_id NUMBER
)RETURN NUMBER IS
new_empno NUMBER;
BEGIN
It works fine if I set space after commas:
CREATE OR REPLACE PACKAGE BODY emp_mgmt AS
tot_emps NUMBER;
tot_depts NUMBER;
FUNCTION hire(
last_name VARCHAR2
, job_id VARCHAR2
, manager_id NUMBER
, salary NUMBER
, department_id NUMBER
)RETURN NUMBER IS
new_empno NUMBER;
BEGIN