Really Global Variables?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Really Global Variables?

  1. #1
    Join Date
    May 2001
    Posts
    3

    Cool

    Hi,

    Has anyone else thought about global variables that's above using packages? Let's say I have 10 packages and 30 views that need access to this super global variable. Yes, I can store it in a table, which is probably what I'm going to do.

    Wouldn't it be nice to pin a variable on the SGA for a period of time?

    any comments?

    --nick

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    True, but considering that you can have Pro*C, PL/SQL and Java packages, making a global variable across all would be tricky. I always make an xGlobalValue_T table in my schemas. This table always holds global values for the databae, such as database version (in app terms, not like 8.1.6.2), directories, last refresh time, etc. I then make a proc/package to easily get the values from the table and pin both - quick and easy.

    - Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width