Hello:

We have many packages with conditional compilation where PL / SQL Beautifer fails.

Here is a simplified example

CREATE OR REPLACE PROCEDURE p_example IS
BEGIN
INSERT INTO test_format (dummy1
$IF $$debug_mode $THEN
, dummy2
$END
)
VALUES
('1'
$IF $$debug_mode $THEN
, '2'
$END
);
END p_example;

Table:


CREATE TABLE test_format (
dummy1 VARCHAR2(10),
dummy2 VARCHAR2(20)
);

ALTER SESSION SET PLSQL_CCFLAGS='debug_mode:TRUE';


Thanks,