ALTER SESSION SET plsql_warnings = 'enable:all'
Statement processed.
CREATE OR REPLACE PROCEDURE plw6002 AUTHID DEFINER
AS
l_checking BOOLEAN := FALSE;
PROCEDURE why_did_i_write_this
IS
BEGIN
DBMS_OUTPUT.put_line ('Why did I write this?');
END;
BEGIN
NULL;
IF l_checking
THEN
DBMS_OUTPUT.put_line ('Never here...');
ELSE
DBMS_OUTPUT.put_line ('Always here...');
GOTO end_of_function;
END IF;
<<end_of_function>>
NULL;
END plw6002;
Warning: PROCEDURE PLW6002 Line/Col: 5/4 PLW-06006: uncalled procedure "WHY_DID_I_WRITE_THIS" is removed. Line/Col: 15/7 PLW-06002: Unreachable codeMore Details: https://docs.oracle.com/error-help/db/ora-20001
DROP PROCEDURE plw6002
Procedure dropped.
CREATE OR REPLACE FUNCTION plw6002
RETURN VARCHAR2
AUTHID DEFINER
AS
BEGIN
RETURN NULL;
DBMS_OUTPUT.put_line ('Never here...');
END plw6002;
Warning: FUNCTION PLW6002 Line/Col: 7/4 PLW-06002: Unreachable codeMore Details: https://docs.oracle.com/error-help/db/ora-20001
SHOW ERRORS PROCEDURE plw6002
Unsupported Command
DROP FUNCTION plw6002
Function dropped.