OraFAQ Forum: Forms » Table which stores history of Forms errors info

Home » Developer & Programmer » Forms » Table which stores history of Forms errors info (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table which stores history of Forms errors info [message #562235]

Mon, 30 July 2012 10:44

godfather1000
Messages: 13
Registered: July 2012

Junior Member

Can some one please tell me which table stores forms error information. My requirement is to compare number of errors and details of all form related errors thrown to all users before and after a cut off date and I'm unable to find the table which stores the history of forms errors for each user

Report message to a moderator

Re: Table which stores history of Forms errors info [message #562245 is a reply to message #562235]

Mon, 30 July 2012 12:48

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

This is something I have never heard of. I think back in Forms 2.3 and 3.0, a text based version of forms, there were tables that were part of the database for forms, but I am not aware of any since then. or if there are, I do not know what they are and do not use them.

Report message to a moderator

Re: Table which stores history of Forms errors info [message #562246 is a reply to message #562235]

Mon, 30 July 2012 12:53

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

You can probably construct an ON-ERROR or ON-MESSAGE trigger to write user errors to your own table.

Report message to a moderator

Re: Table which stores history of Forms errors info [message #562255 is a reply to message #562246]

Mon, 30 July 2012 13:35

godfather1000
Messages: 13
Registered: July 2012

Junior Member

Thank you both for your responses. This is not specific to a particular form. The The requirement is to find forms error history for each user based on error date.

Report message to a moderator