Retaining data across sessions
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.
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?
Click Here to Expand Forum to Full Width