after servererror trigger

Hi, help please catch objects names that appear in error messages, my trigger logs in table messages like "ORA-00001: unique constraint (.) violated", how can I log message with constraint name?

Here text of my trigger:

begin
-- let get session info

err_n:=ora_server_error(1);
-- this function returns right ip address
select sys_context('USERENV','IP_ADDRESS') into ip from dual;
select sys_context('USERENV','TERMINAL') into terminal from dual;
select sys_context('USERENV','OS_USER')
into os_user from dual;
msg:=SQLErrM(-err_n);
-- let log info

INSERT INTO system.server_error$
(username, error_code, msg,ip,terminal,os_user) values (ora_login_user, err_n, msg,ip,terminal,os_user); end;

Thanx! Received on Thu Jan 31 2002 - 05:34:53 CST