create or replace procedure compiler_wrong_hint
/*
Compilation errors for PROCEDURE NSMEP.COMPILER_WRONG_HINT
Error: Hint: Value assigned to 'l_hint_var' never used in 'compiler_wrong_hint'
Line: 12
Text: l_hint_var:= 'xxx';
*/
is
l_hint_var varchar2(100);
begin
l_hint_var:= 'xxx';
--
begin
null;
exception
when others then
dbms_output.put_line(l_hint_var);
end;
end;
create or replace procedure compiler_wrong_hint is l_hint_var varchar2(100) := 'xxx'; begin -- begin null; exception when others then dbms_output.put_line(l_hint_var); end; end;