RE: Redeclaration of Global variables...

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 16 Mar 2006 17:36:45 -0500
Message-ID: <KNEIIDHFLNJDHOOCFCDKEECAHNAA.mwf@rsiz.com>

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_at_rsiz.com
36 West Street
Lebanon, NH 03766-1239
tel: (603) 448-1803

---

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Carlos Reyes Pacheco
Sent: Thursday, March 16, 2006 12:28 PM
To: Oracle-L_at_freelists.org
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.
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 16 2006 - 16:36:45 CST