Help with super procedures and Appserver

[cdcastroi]

I would appreciate any help with this issue I'm dealing with. My appserver environment is stateless. In a appserver process, I'm running a persistent procedure and setting it up as a super procedure on the session handle, and it is available for as long as the process is running. When that particular process ends, the super procedure is still available, and several other proceses thereafter are able to see all the values set on it If they q . This is an undesirable behavor for my application, is it a way to make the super procedure available only to a particular session? I thougth the session system handle would be scoped only to a particular appserver process, but it seems like it is scoped to the whole appserver environment.

Thanks in advance for your help

Cesar Castro

 

[Stefan De Leyn]

Try going through all the handles of the Session when the process ends in the following way.


han = SESSION:FIRST-PROCEDURE.
do while valid-handle(han):
if han:file-name = "myproc.p" /* your procedure name */ then
delete procedure han.
else han = han:next-sibling.
end.

By doing this you should come across your procedure and it will be deleted with all related results.