1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Forms 10g, recording all errors happening at forms to database table

Discussion in 'Oracle Forms and Reports' started by member.forums@gmail.com, Jun 4, 2009.

  1. member.forums@gmail.com

    member.forums@gmail.com Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    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
    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
     
  2. Kirti

    Kirti Forum Advisor

    Messages:
    46
    Likes Received:
    12
    Trophy Points:
    130
    Hi well forms handle errors at the form-level through the On-Error trigger. So if you want to achieve this you will need to modify the on-error trigger in your form. You can try with creating a PLL_On_Error trigger in a PLL library and call it from your form's on-error trigger.

    But i don't really understand why you would want to do this though.