User selects View | Formatting Options | Comment Generation | Recommendations and under "Setup" he selects "Inline Comments". He then leaves Advice "553 Unreferenced Variable" checkmarked under Formatting Options | Code Review Options.
When he formats code (see example below), "ADVICE: [553] Unreferenced variable" is given in error or is not the correct / wrong advice.
Example:
==================================================================
CREATE OR REPLACE PACKAGE BODY test AS
PROCEDURE test_proc AS
l_output VARCHAR2(1000);
l_duration INTERVAL DAY TO SECOND := LOCALTIMESTAMP - m_package_start_time;
/* ADVICE: [553] Unreferenced variable */
BEGIN
SELECT CHR(10)
|| TO_CHAR((EXTRACT(MINUTE FROM l_duration) * 60) + ROUND(EXTRACT(SECOND FROM l_duration), 2), '9,990.00')
|| ' seconds'
INTO l_output
FROM DUAL;
log_helper.put_line(l_output);
END test_proc;
END test;
==================================================================
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center