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 LOGON on opening every form

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

  1. member.forums@gmail.com

    member.forums@gmail.com Active Member

    Likes Received:
    Trophy Points:
    I have an after logon trigger on my db which records all logons to it through sql and through forms into a table.
    Now the problem is that whenever I open a new form from the menu a logon event happens, like
    1. I login to forms using form logon window ---- 1 insert to the logon table
    2. I open new form -----------1 more insert goes to the logon table.
    and so on.

    Also evry form logs a new sesion with a different session id.

    Why are my forms logging in to db upon opening every other form?
    how can i correct this?
    any help would be highly appreciated..