RE: referencing package variables
- From: "Nick Tilbury @ Northampton" <ntilbury@xxxxxxxxxxxx>
- To: "'Foelz.Frank@xxxxxxxxxxxxxxxxxxx'" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 22 Dec 2004 09:31:17 -0000
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 =
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 <
--
//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.
=======================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
