NHibernate, Oracle and sql instrumentation

Question

Hopefully I can express this in a coherent and meaningful way:

Two of our DBA's came up to me today after an email I sent explaining why we were using NHibernate and the benefits of an ORM framework. They have been pushing hard for refactoring our stored procs to include instrumentation like this:

BEGIN DBMS_APPLICATION_INFO.set_module(module_name => 'Human Resources' ,action_name => 'Get Employees');

{sql here}

DBMS_APPLICATION_INFO.set_module(NULL, NULL);

My questions really stem around how could we accomplish this, are there any huge caveats that would recommend against finding an implementation for this, if this is too painful, are there alternatives.

Thank you in advance, -sean

Answer 1

Seems like what you need is auditing? Maybe http://stackoverflow.com/questions/15917/data-auditing-in-nhibernate-and-sqlserver and http://www.shawnduggan.com/?p=89 can help you out