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!

Oracle 10g key combination to call form trigger

Discussion in 'SQL PL/SQL' started by Lanlani, Nov 11, 2009.

  1. Lanlani

    Lanlani Active Member

    Likes Received:
    Trophy Points:

    I need to fire the KEY-DUPREC trigger as I click on the key combination Shift+P therefore; I added the following line of code in the frmweb.res file.

    80 : 1 : "Shift+P" : 64 : "Duplicate Record"

    It worked iff no error was raised. So, if I have a raise form trigger failure in the KEY-DUPREC trigger, a capital P will appear in the text field that called the trigger.

    Can you please suggest a solution for preventing the capital P from appearing in the text field if a raise trigger failure existed in the KEY-DUPREC.

    Thanks in advance