How to find out what schema a PL/SQL package is running from

  –—————————————————————————————————————
  — This private function will return who owns the package
  — used for any call backs to prevent the use of synoynms picking up the
  — wrong guy…
  — Needs to get it from dual to get what permissions we are running with
  – not who we are running it as – confused? You will be …
  –
  –—————————————————————————————————————
  function get_callback_schema( p_object_name in varchar2 default null ) return varchar2
  is
  q varchar2(200);
  begin
    select sys_context( ‘userenv’, ‘current_schema’) || ‘.’ || p_object_name
    into q from dual ;
    return q ;
  end get_callback_schema ;