This discussion is archived
3 Replies Latest reply: Sep 15, 2009 11:12 PM by 703441 RSS

working with global temp table and apex

570239 Newbie
Currently Being Moderated
Hello,

I have defined several global temporary tables to store report results in but now it seems that diffrent users with different sessions are getting partials of information of each other????? How can avoid this? I'm also using SSO/WNA authentication for this application
We base also several LOV on the result set in the GTT but it seems to be mixing up things over different sessions
any help would be very appreciated

Thanks
Erwin
  • 1. Re: working with global temp table and apex
    Jes Oracle ACE
    Currently Being Moderated
    Hello,

    As you've found, GTT's can be problematic in an environment like APEX (which does not guarantee you'll get the same DB session connection each time, since they are pooled).

    A much better alternative is to use Collections, which you can read about here -

    http://download.oracle.com/docs/cd/E10513_01/doc/appdev.310/e10499/advnc.htm#BABFFJJJ

    Hope this helps,

    John.
    --------------------------------------------
    Blog: http://jes.blogs.shellprompt.net
    Work: http://www.apex-evangelists.com
    Author of Pro Application Express: http://tinyurl.com/3gu7cd
  • 2. Re: working with global temp table and apex
    570239 Newbie
    Currently Being Moderated
    Hi John,

    Will this not affect performance?
    I haven't worked a lot with collections before

    I insert and update on the temp table with a package. (large pl/sql control)

    So replacing the insert update , delete on the temp tables by the apex_collection methods should do the trick?


    Erwin
  • 3. Re: working with global temp table and apex
    703441 Newbie
    Currently Being Moderated
    hi

    i have used collections table is there any way to update the columns (ie.using update memberattribute) inside a for loop and i want to use ( for update.....where current of )row locks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points