Re: Declaring constants in PG/PLSQL

On Mon, 2002-01-21 at 14:37, Mark Hesketh wrote:
>   Hi all,
>
> Can someone tell me if it's possible to globally scope my constants? How
> do I declare them for reuse? Don't tell me I have to keep defining them
> atop each function... :|

Why not create some functions that return your constants?

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "For we wrestle not against flesh and blood, but
      against principalities, against powers, against the
      rulers of the darkness of this world, against
      spiritual wickedness in high places. Wherefore take
      unto you the whole armour of God, that ye may be able
      to withstand in the evil day, and having done all, to
      stand."              Ephesians 6:12,13