Rich Pascual richardpascual

richardpascual / oracle-plsql-exception-handling.sql

Created July 30, 2014 02:24

Example of implementation of DBMS_APPLICATION_INFO in Oracle PL/SQL (10g and later)

	-- This is an example framework of how to implement tracking of package/procedure/function plsql
	-- procedural code execution (Oracle) with a built-in package: DBMS_APPLICATION_INFO; the intent
	-- is to set this syntax layout up so that developers can have a flexible, customizable syntax
	-- to accomplish this task.

	-- Look for my project here on Github, the ORA-EXCEPTION-HANDLER. (richardpascual)

	CREATE or REPLACE PROCEDURE PROCESS_TWEET_LOG is
	c_client_info constant V$SESSION.CLIENT_INFO%TYPE := 'DEV-DATABASE, OPS408 SCHEMA';
	c_module_name constant V$SQLAREA.MODULE_NAME%TYPE := 'PROCESS_TWEET_LOG';