history of all error [message #284397] |
Thu, 29 November 2007 09:16 |
Rafeek
Messages: 159 Registered: April 2007 Location: egypt
|
Senior Member |
|
|
hi all
i use oracle database 10g and forms 6i.
i want to create history of all error (ora-frm-rep).
i create ora on database (trigger)
how can i get all frm and rep error?
thax
Rafeek
==============================================
CREATE OR REPLACE TRIGGER catch_errors
after servererror on database
declare
sql_text ora_name_list_t;
msg_ varchar2(2000) := null;
stmt_ varchar2(2000) := null;
begin
for depth in 1 .. ora_server_error_depth loop
msg_ := msg_ || ora_server_error_msg(depth);
end loop;
for i in 1 .. ora_sql_txt(sql_text) loop
stmt_ := stmt_ || sql_text(i);
end loop;
insert into
caught_errors (dt , username ,msg ,stmt )
values (sysdate, ora_login_user,msg_,stmt_);
end;
/
==============================================
|
|
|
|