AW: referencing package variables

  • From: "Foelz.Frank" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 22 Dec 2004 10:43:42 +0100

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


> Frank<

-----Urspr=FCngliche Nachricht-----
Von: Nick Tilbury @ Northampton [mailto:ntilbury@xxxxxxxxxxxx]=20
Gesendet: Mittwoch, 22. Dezember 2004 10:31
An: 'Foelz.Frank@xxxxxxxxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Betreff: RE: referencing package variables

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

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
Behalf Of Foelz.Frank
Sent: 22 December 2004 09:29
To: oracle-l@xxxxxxxxxxxxx
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"


Other related posts: