Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQLServer ->Oracle : IF UPDATE(Column)....

SQLServer ->Oracle : IF UPDATE(Column)....

From: zfred <zfred_at_ozemail.com.au>
Date: Fri, 20 Nov 1998 11:15:44 +1100
Message-ID: <3654B4AF.F70A251A@ozemail.com.au>



In sql server you can do in a Trigger

     If Not UPDATE(AuditUserId)
     Begin
           Select @Msg = "Failed to Audit userid"
           Goto Error
     End

thus checking that the user of an UPDATE sql did indeed also set the AuditUserId
column.

Oracle appears to have quite a set of trigger options, including one
where A trigger is called  for a specified column update BUT i don't think
this will work for me,
because when the row updates,  ie another trigger - update of the table -
i need to check that the AuditUserId was set
AND  the old and new value of AuditUserId could be the SAME!!

By the way: I am using Oracle Lite 3.5

I am out of ideas for porting this one!
anyone got an idea ?
i'll be so thankful.
 
  Received on Thu Nov 19 1998 - 18:15:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US