RE: referencing package variables
- From: David Lord <DLord@xxxxxxxxxxxxxxxxxx>
- To: "'Foelz.Frank@xxxxxxxxxxxxxxxxxxx'" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 22 Dec 2004 09:57:06 -0000
Frank,
You could use a bind variable: -
SQL> variable foobar varchar2
SQL> begin :foobar := mypkg.constant; end;
2 /
SQL> select :foobar from dual;
--
David Lord
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Foelz.Frank
> Sent: 22 December 2004 09:48
> To: oracle-l@xxxxxxxxxxxxx
> Subject: AW: referencing package variables
>
>
> Nick, got it, Thank's
>
> there is no other (more practical) way to do that ???
>
> > 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 ?
>
> --
> //www.freelists.org/webpage/oracle-l
>
This email and its attachments are confidential under applicable law and are
intended for use of the sender's addressee only, unless the sender expressly
agrees otherwise, or unless a separate written agreement exists between Iron
Mountain and a recipient company governing communications between the parties
and any data that may be so transmitted. Transmission of email over the
Internet is not a secure communications medium. If you are requesting or have
requested the transmittal of personal data, as defined in applicable privacy
laws, by means of email or in an attachment to email, you may wish to select a
more secure alternate means of transmittal that better supports your
obligations to protect such personal data.
If the recipient of this message is not the recipient named above, and/or you
have received this email in error, you must take no action based on the
information in this email. You are hereby notified that any dissemination,
misuse or copying or disclosure of this communication by a recipient who has
received this message in error is strictly prohibited. If this message is
received in error, please return this email to the sender and immediately
highlight any error in transmittal. Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
