Re: AW: referencing package variables

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Wed, 22 Dec 2004 02:39:30 -0800 (PST)
Message-ID: <20041222103930.92234.qmail@web52606.mail.yahoo.com>

Maybe pipleined function can help you if you are
>=9.2.

and just do directly select on the function.

select * from pkg.func(:name_of_variable);

You can use where
That will be less load then reading it from user_source I think.

Regards,
Zoran                 

---

Do you Yahoo!?
Send holiday email and support a worthy cause. Do good. http://celebrity.mail.yahoo.com

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

Received on Wed Dec 22 2004 - 04:34:51 CST