Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

global variable scope

761897Aug 18 2010 — edited Aug 18 2010
I have a question about global variable scope. I have one package named PKG_GLOBAL_VARIABLE where in I have declared few variables which are being used by the trigger.

Now I have one row based and one statement based trigger. In row based trigger I take the value of :new and :old values and assign it to the global variables and then in the statement level triggers I perform operations with the help of these values. All this is happening in one transaction. I wanted to know what will happen if simultaneously more than one transaction is occuring? What will the values of these global variables? Will it be transaction specific? Also what are the possibilities when there can be issue with the values assigned to global variables.

Thanks for help in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2010
Added on Aug 18 2010
8 comments
1,393 views