RE: Redeclaration of Global variables...

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <juancarlosreyesp@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Thu, 16 Mar 2006 17:36:45 -0500

Didn't you get a warning?

I would expect that your package would still work, because the first
definition of the variable should work and the second should fail, but later
reference to g_num will suceed, there is no need to actually fail.

mwf

------------------------------------
Rightsizing, Inc.
Mark W. Farnham
President
mwf@xxxxxxxx
36 West Street
Lebanon, NH 03766-1239
tel: (603) 448-1803
------------------------------------


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Juan Carlos Reyes
Pacheco
Sent: Thursday, March 16, 2006 12:28 PM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Redeclaration of Global variables...


Hi
I think this is a bug, because you can create the same variable, using
the same datatype.

create or replace package glb_test as
g_num number;
g_num number;
end;
/

I think nobody had found this bug, or if did, no body reported it, and
that is the reason why you still see it.
--
//www.freelists.org/webpage/oracle-l



--
//www.freelists.org/webpage/oracle-l


Other related posts: