Re: how to use of constant in a package?

Sandeep Patwardhan wrote:
>
> 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

You should create functions in the package to return the value of each constant / variable. Provided they are created with the appropriate restrict_references pragmas, these can be referenced within SQL statements.

Within PL/SQL procedures, of course, the constants can be referenced directly.

HTH

-- 
Chrysalis

FABRICATI DIEM, PVNC
('To Protect and to Serve')
Terry Pratchett : "Guards Guards"