Print Thread
Wrong compiler hint in program window
#16220 10/26/04 02:03 PM
Joined: Nov 2003
Posts: 25
Ukraine
M
Member
OP Offline
Member
M
Joined: Nov 2003
Posts: 25
Ukraine
Code
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;

Re: Wrong compiler hint in program window
#16221 10/26/04 03:58 PM
Joined: Oct 2004
Posts: 1
R
Member
Offline
Member
R
Joined: Oct 2004
Posts: 1
initialization error
SQL*Net not properly installed

OracleHomeKey:
OracleHomeDir:

Re: Wrong compiler hint in program window
#16222 10/26/04 09:50 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
@Michael Maramzin: This is indeed not correct, we'll fix it.

@rumi: It seems that you do not have Oracle Net installed. This is a requirement.


Marco Kalter
Allround Automations
Re: Wrong compiler hint in program window
#16223 10/27/04 12:27 AM
Joined: Nov 2003
Posts: 6
JHU Applied Physics Lab
Member
Offline
Member
Joined: Nov 2003
Posts: 6
JHU Applied Physics Lab
Interesting, no error for this:

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;

Re: Wrong compiler hint in program window
#16224 10/27/04 09:52 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
The default value of the variable is not treated as an assignment by the hint system.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.039s Queries: 13 (0.010s) Memory: 2.5155 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-18 04:17:03 UTC
Valid HTML 5 and Valid CSS