Trigger Problem

From: <amerar_at_ci.chi.il.us>
Date: Tue, 31 Aug 1999 18:55:32 GMT
Message-ID: <7qh8es$2oc$1@nnrp1.deja.com>

Hello,

Can someone please tell me why this trigger fails re-validation? Also, where do the messages go when you compile a trigger?

BEGIN
UPDATE audit_trail

   SET user_id = (

      select osuser from v$session where audsid=userenv('SESSIONID'))    WHERE

      payment_history_key = :new.payment_history_key and
      caps_code = :new.caps_code and
      adjustment_date_time = :new.adjustment_date_time and
      fund# = :new.fund# and
      adj_amt_cash = :new.adj_amt_cash and
      adj_amt_check = :new.adj_amt_check and
      adj_amt_credit = :new.adj_amt_credit and
      adj_advice_of_credit = :new.adj_advice_of_credit and
      adj_int = :new.adj_int and
      adj_pen = :new.adj_pen and
      adj_fund_amt = :new.adj_fund_amt and
      adj_letter_of_credit = :new.adj_letter_of_credit and
      adj_electronic_fund_xfer = :new.electronic_fund_xfer and
      adj_credit_others = :new.adj_credit_others and
      adj_food_stamps = :new.adj_food_stamps and
      notes = :new.notes and
      date_time_batch_closed = :new.date_time_batch_closed;

END; Thanks,

Arthur

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 31 1999 - 13:55:32 CDT