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 = constants
in the package header) in a simple sql statement ?

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

any help would be appreciated

> Frank =D3=BF=D2 <

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


=======================================================
This message is intended solely for the use of the individual or organisation to whom it is addressed.  It may contain privileged or confidential information.  If you have received this message in error, please notify the originator immediately.  If you are not the intended recipient, you should not use, copy, alter, or disclose the contents of this message.  All information or opinions expressed in this message and/or any attachments are those of the author and are not necessarily those of VarTecTelecom Europe Ltd or its affiliates. VarTec Telecom Europe Ltd accepts no responsibility for loss or damage arising from its use, including damage from virus. 
=======================================================

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