DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005

    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.

    Mark Twite

  2. #2
    Join Date
    Nov 2001
    The Netherlands

    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?



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width