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!

update trigger oracle10g forms and reports 9i

Discussion in 'Oracle Forms and Reports' started by ksjj, Jan 23, 2014.

  1. ksjj

    ksjj Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    hi,

    i need help in using trigger to update a column in one table when a record is inserted in another table.

    I am not sure if i am making it clear. will try to explain in detail

    There is a table AUTHORITY where pensionery benefits are authorized for a particular authorisation no.

    For having made payment , a voucher will be sent and this is posted in another table voucher.

    What i require is when this voucher is posted in VOUCHER table and saved, there should be a "Y" UPDATED in AUTHORITY table in column name 'AUTH_PAID'

    the link between these two tables in the AUTHORITY.AUTH_PK=VOUCHER.VCH_AUTH_PK

    which trigger should i use and in which table it should be used either in VOUCHER TABLE OR IN AUTHORITY TABLE. Alternatively should the trigger be in database.

    since i do not have much knowledge on these triggers, a coding for this will be of great help.
    thanks in advance
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    For this you need After insert trigger.

    Refer below links to understand the After insert triggers.

    Link1

    Link2

    Link3