Home » Developer & Programmer » Forms » history of all error
history of all error [message #284397] Thu, 29 November 2007 09:16 Go to next message
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;
/

==============================================
Re: history of all error [message #284400 is a reply to message #284397] Thu, 29 November 2007 09:24 Go to previous message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Have a look at the ON-ERROR trigger in forms, this can be used to capture form errors.

Previous Topic: How set image value null
Next Topic: How to run FMX File
Goto Forum:
  


Current Time: Fri Dec 09 00:17:04 CST 2016

Total time taken to generate the page: 0.11826 seconds