Best Practices

##PL/SQL Procedure / Function Template

For packages the recommended practice is as follows:

create or replace package body pkg_example
as

  gc_scope_prefix constant VARCHAR2(31) := lower($$PLSQL_UNIT) || '.';
  
  procedure demo_proc(
    p_param1 in varchar2)
  as
    l_scope logger_logs.scope%type := gc_scope_prefix || 'demo_proc'; -- Use the function or procedure name
    l_params logger.tab_param;
  begin
    logger.append_param(l_params, 'p_param1', p_param1);
    logger.log('START', l_scope, null, l_params);
    
    ...
    -- All calls to logger should pass in the scope
    ... 
    
    logger.log('END', l_scope);
  exception
    when others then
      logger.log_error('Unhandled Exception', l_scope, null, l_params);
      raise;
  end demo proc;

  ...
  
end pkg_example;