Retaining data across sessions

[marktwite]

I am trying to find a way to keep data active across sessions.
It would be nice to use a GTT, but you lose that info when the session closes.
I have a program that calls a procedure 'A', returns to the program which may make a call to another program, then calls another procedure 'B'.
I need to hold individual edit tracking information throughout the process. This information can be from 1 to 200 items.
I need the information from procedure 'A' when commiting data from the program(s) in procedure 'B'.
I could define a physical table to temporarily store the info within, then delete from that table when the final process is perform in procedure 'B'.
I would like to retain this tempoary information in memory, but cannot find a way to do it.
If I can keep the session from procedure 'A' alive and refer to it in the session from procedure 'B'. Then close both sessions??
Any thoughts on this would be appreciated.

Thanks,
Mark Twite

[Alien]

Hi,

I'm a bit confused by your question.
Why do you loose your session when you exit a procedure?
Are you sure that you're getting a different session, in procedure B? Are you using pragma autonomous_transaction?

Regards,

Arian