| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: global variables
A copy of this was sent to "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
(if that email address didn't require changing)
On Sat, 12 Jun 1999 10:38:17 +0100, you wrote:
>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
>
nope, contexts are session specific -- just like package variables. See http://govt.us.oracle.com/~tkyte/ , the paper on fined grained access control, to see a description and use of application contexts...
>--
>
>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
>>
>
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/
Current article is "Fine Grained Access Control", added June 8'th
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA--
 |
 |