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@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, =
surely
you can issue a text matching search on the DBA|USER_SOURCE view =
couldn't
you ?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
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"

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

Other related posts: