Re: Is this a bug...
From: Michael J. Moore <hicamel_x_the_spam_at_attbi.com>
Date: Thu, 12 Sep 2002 19:05:37 GMT
Message-ID: <5A5g9.284958$_91.326426_at_rwcrnsc51.ops.asp.att.net>
Date: Thu, 12 Sep 2002 19:05:37 GMT
Message-ID: <5A5g9.284958$_91.326426_at_rwcrnsc51.ops.asp.att.net>
Aparently that last assignment is the one that takes ... try
set serverout on
exec dbms_output.put_line(testpkg.foo);
then move your assignments around, recompile and exec again.
"RK" <rajXesh_at_hotmail.com> wrote in message
news:548b9514.0209120544.539306df_at_posting.google.com...
> Is this a bug?
>
> I can define a package as
>
>
> CREATE OR REPLACE PACKAGE testpkg AS
>
> TYPE foo IS REF CURSOR;
> foo NUMBER;
> foo VARCHAR2 (5);
> foo DATE;
> foo CONSTANT number := 4;
> foo CONSTANT varchar2(6) := 'QWERTY';
> foo CONSTANT date := SYSDATE;
>
> END testpkg;
Received on Thu Sep 12 2002 - 21:05:37 CEST