I have created a trigger to do something with the previous value of a particular 
record. My trigger def looks like this:

CREATE TRIGGER ANNOUNCEMENT_UPDATE FOR ANNOUNCEMENT AFTER UPDATE EXECUTE 
(
TRY
    INSERT INTO ANNOUNCEMENT_HISTORY VALUES 
    (
        :OLD.ANNOUNCEMENT_GID,
        :OLD.BODY
    )
CATCH
  IF $rc <> 100
  THEN STOP ($rc, 'unexpected error');
)

Field BODY is of type LONG. I get this error message when I try to create this trigger:

General error;-9000 POS(116) System error: Not yet implemented:OLD of datatype LONG.

Has anyone figured out a way to work around this limitation? 

Thank you,
Vitaly Veksler

Reply via email to