Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10.2 Bug?

Re: 10.2 Bug?

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Wed, 8 Feb 2006 17:26:54 +0000
Message-ID: <uV4OX2Geni6DFwjO@jimsmith.demon.co.uk>


In message <1139418452.832902_at_jetspin.drizzle.com>, DA Morgan <damorgan_at_psoug.org> writes
>I know ... I know ... but this seems to be worth reporting but I would
>like someone else to confirm it.
>
>SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 8 09:05:54 2006
>
>Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
>
>Connected to:
>Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
>With the Partitioning, OLAP and Data Mining options
>
>SQL> ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';
>
>Session altered.
>
>SQL> CREATE OR REPLACE PROCEDURE dead_code AS
> 2 x NUMBER := 10;
> 3 BEGIN
> 4 IF x = 10 THEN
> 5 x := 20;
> 6 ELSE
> 7 x := 100; -- dead code (never reached)
> 8 END IF;
> 9 END dead_code;
> 10 /
>
>SP2-0804: Procedure created with compilation warnings
>
>SQL> show err
>Errors for PROCEDURE DEAD_CODE:
>
>LINE/COL ERROR
>-------- -------------------------------------------------------------
>4/8 PLW-06002: Unreachable code
>7/5 PLW-06002: Unreachable code
>SQL>
>
>This change in behaviour, reporting line 4 as unreachable, did not
>occur in 10.1.0.4.
>

I can reproduce it on 10.2.0.1.0 on Linux. (Although strangely, not using 9.2 sql*plus)

-- 
Jim Smith
I'm afraid you've mistaken me for someone who gives a damn.
Received on Wed Feb 08 2006 - 11:26:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US