Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

RE: Redeclaration of Global variables...

Christian Antognini

2006-03-16

Replies:

>On 3/16/06, Juan Carlos Reyes Pacheco <juancarlosreyesp@(protected):
>> 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.

SQL> show parameter plsql_warnings

NAME                      TYPE     VALUE
------------------------------------ ----------- ----------------------
plsql_warnings               string    ENABLE:ALL
SQL> create or replace package glb_test as
2 g_num number;
3 g_num number;
4 end;
5 /

SP2-0808: Package created with compilation warnings

SQL> show error
Errors for PACKAGE GLB_TEST:

LINE/COL ERROR
-------- --------------------------------------------------------------
3/1    PLW-05001: previous use of 'G_NUM' (at line 2) conflicts with
     this use


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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.