Re: global variables

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 12 Jun 1999 10:38:17 +0100
Message-ID: <929180546.24518.1.nnrp-10.9e984b29@news.demon.co.uk>

If this is in SQL -
Then create a package without a body, but declaring some variables.

Persistence is NOT the same as for tables though, as each instantiation of the package is local to a single session, but it may get you somewhere closer to where you want to be.

You could possibly play games with CONTEXTs in Oracle 8i though - I'll have to think about that one

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Dan Hess wrote in message <3761AE7B.C2FF344E_at_cornell.edu>...
>I'm sure this is basic, but how can I declare global variables to
>persist outside of blocks, just as tables do?
>
>For example, how would I declare a counter variable containing the
>number of times a table is accessed, that has the same accessability as
>the table?
>
>Thanks a million,
>Dan
>
Received on Sat Jun 12 1999 - 04:38:17 CDT