Home » SQL & PL/SQL » SQL & PL/SQL » Is there any Data dictionary table to track a package variable?
Is there any Data dictionary table to track a package variable? [message #269121] Thu, 20 September 2007 14:51 Go to next message
puneet.kakkar
Messages: 11
Registered: February 2007
Junior Member
Hi,

I have a requirement where in i want to audit a package variable from time to time. Do we have any database table which stores the variable with its last value?

Thanks,
Puneet
Re: Is there any Data dictionary table to track a package variable? [message #269122 is a reply to message #269121] Thu, 20 September 2007 14:53 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is one instance of a package variable per session using it, so there is no global last value.

Regards
Michel
Previous Topic: inconsistent datatypes: expected - got -
Next Topic: how can i solve this query
Goto Forum:
  


Current Time: Wed Dec 07 16:38:08 CST 2016

Total time taken to generate the page: 0.09184 seconds