AW: referencing package variables

Nick, can you throw a little more light on this, please.=20

TNX
> Frank<

-----Urspr=FCngliche Nachricht-----
Von: Nick Tilbury @ Northampton [mailto:ntilbury_at_vartec.co.uk]=20 Gesendet: Mittwoch, 22. Dezember 2004 10:31 An: 'Foelz.Frank_at_Scheidt-Bachmann.de'; oracle-l_at_freelists.org Betreff: RE: referencing package variables

If you know the variables/constant names and the name of the package, = surely
you can issue a text matching search on the DBA|USER_SOURCE view = couldn't
you ?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Foelz.Frank
Sent: 22 December 2004 09:29
To: oracle-l_at_freelists.org
Subject: referencing package variables

Hi gurus,

working on oracle 9.x on WinXP.

is there a possibility, to reference package variables (defined as =3D constants in the package header) in a simple sql statement ?

i.e. "Select pkg.constant1 from dual"

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