how to use of constant in a package?

Hi,

    I have a stored package wherein I have defined all constants.     How can I make use of this constant in where clause of select statement for my view.

    e.g I have a package declare_const and have a constant, x defined in it

    I want to use it as -
    create view test as
    select * from table_name
    where column = declare_const.x

I would really be thankful if anyone could please solve this problem Thanks,
Sandeep
mail:patwardhan_at_logica.com Received on Fri Aug 08 1997 - 00:00:00 CDT