CREATE OR REPLACE TRIGGER “tsu_PHONE_NUMBERS_SEQ_PHONE__0” AFTER UPDATE OF “PHONE_ID”
I want to be able to specify an ID and only use the sequence if the ID is null or not supplied for an insert, so I need to specify my own trigger that is associated with the sequence.
How can I alter the trigger that TDM generates for a sequence? I looked through the generated script and it looks like the following:
ON “PHONE_NUMBERS” FOR EACH ROWRAISE_APPLICATION_ERROR(-20010,‘Cannot update column “PHONE_ID” in table “PHONE_NUMBERS” as it uses sequence.’);
Message was edited by: cpisz_515