Skip to Main Content

databasetrigger on update needs the name of the form where the change comes

Robert KochAug 21 2011 — edited Aug 21 2011
I want to make a databasetrigger when field status is amended, that I get an insert into another table. There I want to see wich form did the amending. What could I place for @@??@@

INSERT INTO R_LOESCH_PROTOKOLL
(TABELLE,
ZAEHLER,
INSERT_USER,
INSERT_DATE
)
VALUES
(@@??@@,
:OLD.ZAEHLER,
USER,
SYSDATE
);
END K_WE_status_aendern;

Regards

Robert
Using xp Prof, Oracle 8i Patch14
Forms 32 Bitversion 6.0.8.23.2
Oracle8i Enterprise Edition Release 8.1.7.0.0
Comments
Post Details
Added on Aug 21 2011
3 comments
36 views