I did the following to resolve my need.
-created page 102
-changed the navigation bar entry settings to "redirect to page 102"
-created on load process on page 102 as to create the coockie as follows
expires => sysdate + 1);
apex_application.g_unrecoverable_error := true;
exception when others then null;
so page 102 creates the coockie ant sets the value of the application item, then goes to &logout_url. automatically
- createn on load process on page 1 (default home page) to read the coockie value as follows
cookie := OWA_COOKIE.get('SCHID_COOKIE');
if cookie.vals.First IS not NULL then
:SCHID := cookie.vals(1);
now I have a question... Do i need to owa_cookie.remove() somewhere?
Sorry, for some reason I didn't see an email for this.
It depends on your requirement, but no, probably not. You could also specify an expiration for the cookie so that it goes away on it's own after X time. The browser will do that for you.
PS. Could I also recommend you flag the posters answers as useful or correct so that they get the incentive of the points? I only mention this because you used my suggestion, but flagged your answer as the correct one.