Kbase P20432: Which version of a SHARED TEMP-TABLE will a PERSISTENT proce
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2003 |
|
Status: Unverified
GOAL:
Which version of a SHARED TEMP-TABLE will a PERSISTENT procedure see?
SYMPTOM(s):
pro defines NEW SHARED TEMP-TABLE tat.
pro instantiates PERSISTENT procedure pp1.p, which has a DEFINE SHARED TEMP-TABLE tt1 statement.
proc1.p makes calls to pp1.p to do things to/with tt1.
proc1.p exits, leaving pp1.p still running.
Later in the same session proc1.p is entered again. It finds pp1.p still running so it doesn't re-start it.
FIX:
At this point in time in the above scenario there will be two SHARED TEMP-TABLEs with the same name in the same progress session. The PERSISTENT procedure pp1.p will be looking at the 'old' version from the initial call of proc1.p.
A SHARED temporary table remains in scope for an instance of a PERSISTENT procedure until the instance of the PERSISTENT procedure is deleted. This is true even if the original procedure that defined the temporary table as NEW SHARED goes out of scope while the procedure instance remains persistent.