Re: automatic update of a variable in pl/sql

Laura, if I understand your question correctly the short answer is NO. You cannot directly tie a pl/sql variables value to a table column value so that the pl/sql variable value dynamically changes when the table column value changes. All pl/sql variables have a session state so that different sessions running the same code at the same time can have different values for the same variables.

If you explain what it is you are trying to do someone may be able to provide a solution.

If you just need the new value of a table column when it changes you may be able to pass it from a table trigger to the stored code routine: package, procedure, or function that is then executed or you might be able to set a system context variable that the code in question references. But how you solve your problem depends on exactly what it is you are tying to do.

HTH -- Mark D Powell -- Received on Wed Mar 23 2005 - 08:02:43 CST