rem application context as cache

create or replace package cache_mgr
as

procedure put_in_cache
( p_key    in varchar2
, p_value  in varchar2
);

end;
/

create or replace context global_cache using cache_mgr ACCESSED GLOBALLY
/


create or replace package body cache_mgr
as

procedure put_in_cache
( p_key    in varchar2
, p_value  in varchar2
) is
begin
  DBMS_SESSION.SET_CONTEXT( 'global_cache',p_key ,p_value);
end put_in_cache;

end;
/


begin
  cache_mgr.put_in_cache
  ( p_key => 'joke of the day'
  , p_value => 'Knock Knock. Who is there? Knock! Knock Who? Knock Knock!'
  );
end;
/
  

select sys_context( 'global_cache', 'joke of the day')
from   dual
/


connect scott/tiger@oracle

select sys_context( 'global_cache', 'joke of the day')
from   dual
/

connect hr/hr@oracle

select sys_context( 'global_cache', 'joke of the day')
from   dual
/