RE: referencing package variables

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_at_freelists.org 

> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Foelz.Frank

> Sent: 22 December 2004 09:48

> To: oracle-l_at_freelists.org

> 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_at_vartec.co.uk]=20

> Gesendet: Mittwoch, 22. Dezember 2004 10:31

> An: 'Foelz.Frank_at_Scheidt-Bachmann.de'; oracle-l_at_freelists.org

> 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 ?

> 

> --

> http://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.



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