This doubt pertains to Oralce forms and Triggers
I have a form which is calling a Trigger
This form can be accessed by many users at a time.
I want to create a variable which would be different for different instances of the form
For this I used the global temporary table
I am able to get the values of inserted record in the global temporary table in the form. But when I try to access this record from the Trigger I get no rows
What might be the problem?
PS: Using sessions is also the solution but I am not looking to use sessions
One alternative to a GLOBAL TEMPORARY TABLE for this particular need (ie the storage of a single value) is to create a package spec with a variable (or add a PACKAGE BODY and use SET and GET functions to set & retrieve the variable's value).
That will allow you to maintain a unique value for each session connected to the database.