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;