5 Replies Latest reply: Apr 6, 2012 5:53 AM by andy.v RSS

    get_session_state don't works after upgrade from 4.1 to 4.1.1.00.23

    andy.v
      Hi!
      I have sentry function, that sets application items after successful authentication. Then values of this itmes are accessed in pl/sql block that sets a context for the database session ("Edit application properties" - "Secutiry").
      All works fine, but there is a problem if page runs from apex builder - values of this items are null!
      Test case on apex.oracle.com:
      1. run page 15 - http://apex.oracle.com/pls/apex/f?p=31741:15
      2. values of items showed in region - they not null
      3. login in apex builder. workspace: WS_AVER, user: VERSALAO, pass: qwerty%
      4. go to page 15, run it from builder
      5. values of items null!
      6. change url in browser to http://apex.oracle.com/pls/apex/f?p=31741:15 (remove session id), then refersh - now all ok! values of item not null.
      this is a bug? or my code has errors?
      thanks.