36 of 38
Usage #6: Example
Create or replace view v_log
As
Select start_session
   (sysdate, user) flag
From dual
function start_session
 (i_dt date,
  i_user varchar2)
  return varchar2
  is
  pragma autonomous_transaction;
Begin
  log_user (i_user, i_dt);
  set_system_defaults;
populate_temp(i_dt, i_user);
commit;
return ‘Y’
Exception
when others return ‘N’;
End;
Select *
From v_log
Log user
Create and
populate
temporary
tables
Set default
environment