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,