Home

DBMS_OUTPUT.PUT_LINE should not be used

Rule description

  • DBMS_OUTPUT.PUT_LINE should not be used

 

Non-compliant Code Example

BEGIN
 IF score > 35 AND score < 50  THEN 
		IF score > 50 AND score < 70 THEN 
				IF score > 70 THEN 
					DBMS_OUTPUT.PUT_LINE('Grade A');  --Non compliant code (DBMS_OUTPUT.PUT_LINE is used)
				END IF;
			DBMS_OUTPUT.PUT('Grade B'); --Non compliant code (DBMS_OUTPUT.PUT is used)
		END IF;
	DBMS_OUTPUT.PUT('Grade C'); --Non compliant code (DBMS_OUTPUT.PUT is used)
 END IF;
END;
Visual Expert 2020
 VEPLSQLRULE140