you can capture the module name as part of your error /excpetion handling mechnism. ensure that you are giving correct program/module names using dbms_application_info. Regards Ajeet On 6/12/07, Gints Plivna <gints.plivna@xxxxxxxxx> wrote:
Are you aware also about dbms_utility.format_call_stack and format_error_stack? Gints Plivna http://www.gplivna.eu 2007/6/12, Krishnadas.Chathamath@xxxxxxxxxxxxxxxxxx > But how to get the last executed sql statement? -- //www.freelists.org/webpage/oracle-l