SQL Developer Version 20.2.0.175 Build 175.1842 on Windows.
I got the files from Philip Salvisberg's github for formatting (https://github.com/Trivadis/plsql-formatter-settings/tree/main/settings/sql_developer ) and imported them into SQL Dev using the following instructions: https://github.com/Trivadis/plsql-formatter-settings#installation.
I am trying to format a big file, almost 6000 lines and I will try to refactor the code, but first I want to format it since it is pretty difficult to read.
I have no experience with arbori and I am wondering if people here have experience with this and can point me to the issues of where to go for more info.
I changed the settings to: 4 spaces, break before a comma and to not have spaces after a comma.
On small block of code the formatting works as I am expecting:
DECLARE
pvr_opuh op_upl_head%rowtype;
pv_ordered_qty op_upl_det.ordered_qty%TYPE;
pvr_arc customer_vw%rowtype;
pvr_arch chain%rowtype;
pvr_dns dnship%rowtype;
pvr_opcp get_customer_price_output%rowtype;
BEGIN
NULL;
END;
/
CREATE PROCEDURE validate_product (
p_product_no IN NUMBER
,p_substitute IN BOOLEAN
) IS
BEGIN
NULL;
END;
/
SELECT column1
,column2
,column3
FROM tabler;
However when I format the big file if shows me stuff like:
DECLARE
pvr_opuh op_upl_head%rowtype;
pv_ordered_qty op_upl_det.ordered_qty%TYPE;
pvr_arc customer_vw%rowtype;
pvr_arch chain%rowtype;
pvr_dns dnship%rowtype;
pvr_opcp get_customer_price_output%rowtype;
BEGIN
NULL;
END;
/
CREATE PROCEDURE validate_product (
p_product_no IN NUMBER
,p_substitute IN BOOLEAN
) IS
BEGIN
NULL;
END;
/
SELECT column1
,column2
,column3
FROM tabler;
Why could that be?