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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Redeclaration of Global variables...

Re: Redeclaration of Global variables...

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Mon, 20 Mar 2006 09:15:14 -0400
Message-ID: <cd4305c10603200515w61f8c8d8me4f1acff31810ae4@mail.gmail.com>


Hi, I checked this,
On 10gr2 you get an error while trying to assing the value to the duplicated variable, on 9i works perfectly. So it seems to be fixed on 10gr2 :)

create or replace package glb_test as
g_num number;
g_num number;
end;
/
EXEC GLB_TEST.g_num:=1;
EXEC DBMS_OUTPUT.PUT_LINE(GLB_TEST.g_num);

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 20 2006 - 07:15:14 CST

Original text of this message

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