Home » Developer & Programmer » Forms » Oracle Forms (10g)
Oracle Forms [message #406425] Wed, 03 June 2009 23:56 Go to next message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
Hi all
I have to capture all errors occuring on my forms GUI.
like FRM and other errors ; all of them.
I have to save them to a table on database.
I have created a procedure to insert these details to the db, and have a solution to call this procedure from every form's code but it is a cumbersome solution and would not be good design

Is there any other way to do it.

Regards

Re: Oracle Forms [message #406427 is a reply to message #406425] Thu, 04 June 2009 00:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is there any other way to do it.
Based upon the lack of details, who would be able to answer?
Re: Oracle Forms [message #406428 is a reply to message #406425] Thu, 04 June 2009 00:10 Go to previous messageGo to next message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
sorry for the less details
What i wanted to know is that is there some central place where all the errors ocurring on the forms are passed through.
because if it is so then may be I can just make that code to insert all errors passing through it to the table.
or else I will have to modify each forms ON-ERROR trigger.

Thanks
Re: Oracle Forms [message #406435 is a reply to message #406428] Thu, 04 June 2009 00:51 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, ON-ERROR / ON-MESSAGE triggers were what I meant to suggest.
Re: Oracle Forms [message #406472 is a reply to message #406435] Thu, 04 June 2009 03:11 Go to previous messageGo to next message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
Do you mean that I should modify all ON-ERROR and ON-MESSAGES triggers of all the data blocks off all the forms or are there some higher level ON-ERROR triggers.
Re: Oracle Forms [message #406476 is a reply to message #406472] Thu, 04 June 2009 03:23 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I guess that form-level trigger(s) will do the job (unless there are block-level ones which will trap the error before the form-level does).
Re: Oracle Forms [message #406478 is a reply to message #406476] Thu, 04 June 2009 03:26 Go to previous messageGo to next message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
I have both form level and block level trigers
to summarize i have 95 total forms and each of them has atleast 2 data blocks
Confused
so it means more time required.
anyways I will go ahead with this approach
Re: Oracle Forms [message #406484 is a reply to message #406478] Thu, 04 June 2009 03:41 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Before you start modifying all of your forms, perhaps you should wait for another opinion.

By the way, what will you do with list of all errors? Will you allow duplicates? If not, how do you plan to handle it?
Re: Oracle Forms [message #406504 is a reply to message #406484] Thu, 04 June 2009 05:20 Go to previous messageGo to next message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
I have to just log all errors whether duplicate or any along with details like ip hostname and all of the person viewing the forms
for some security implementations
Re: Oracle Forms [message #407399 is a reply to message #406504] Wed, 10 June 2009 01:42 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Isn't there a database audit facility that can handle this?

David
Re: Oracle Forms [message #407485 is a reply to message #407399] Wed, 10 June 2009 05:43 Go to previous message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
There is audit trail feature that can be used
but it is not permitted by the client.

Anyways, I am still working on modifying all on_error and on-message triggers of my forms.
Previous Topic: Urgent: Export images from Database to OS
Next Topic: Spell Check from Forms - Not working for data over 4000 bytes (merged 2)
Goto Forum:
  


Current Time: Thu Feb 06 19:21:52 CST 2025