3 Replies Latest reply: Sep 16, 2009 1:12 AM by vishnu prakash RSS

    working with global temp table and apex

    570239
      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
          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
            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
              vishnu prakash
              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