Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Saving a constant into the Oracle schema?
Thomas wrote:
> "DA Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3E8A0009.249ED3D2_at_exxesolutions.com...
> > Sybrand Bakker wrote:
> >
> > > On Tue, 01 Apr 2003 10:49:14 -0800, DA Morgan
> > > <damorgan_at_exxesolutions.com> wrote:
> > >
> > > >Or enter it into a table.
> > > >
> > > >Daniel Morgan
> > >
> > > That is too obvious, isn't it. And it requires at least one logical
> > > I/O
> > >
> > > Sybrand Bakker, Senior Oracle DBA
> > >
> > > To reply remove -verwijderdit from my e-mail address
> >
> > True. But on the other hand it saves changing source code and running an
> > application module back through QA testing every six months.
> >
> > Daniel Morgan
> >
>
>
>
Then here's a compromise between Sybrand and myself guaranteed to work.
Put the value into a table and read it into a global session variable using the initialization section of a package. Then you have a millisecond performance hit when connecting and never have to validate it again.
Daniel Morgan Received on Wed Apr 02 2003 - 11:57:02 CST