Does Falcon support triggers - or should I be worried
Posted by:
Ken Brown
Date: April 06, 2009 03:33AM
Got a table with a before insert trigger but it does not fire - even when I change the trigger code below to constants
Does Falcon support triggers or am I missing something
DDL and DML extract
CREATE TABLE IF NOT EXISTS `Plan`.`P_SEC_OBJ` (
`SEC_OBJ_PK` INT UNSIGNED NOT NULL ,
`SESSION_ID` INT UNSIGNED NOT NULL ,
`CREATE_NAME` VARCHAR(45) NOT NULL ,
`CREATE_STAMP` DATETIME NOT NULL ,
`UPDATE_NAME` VARCHAR(45) NOT NULL ,
`UPDATE_STAMP` DATETIME NOT NULL
`SEC_OBJ` VARCHAR(45) NOT NULL ,
PRIMARY KEY (`SEC_OBJ_PK`) )
ENGINE = Falcon;
create trigger tbi_P_SEC_OBJ
before insert on P_SEC_OBJ
for each row
begin
set new.sec_obj_pk = getseq('GEN');
set new.session_id = getseq('GEN');
set new.create_name = current_user();
set new.create_stamp = now();
set new.update_name = current_user();
set new.update_stamp = now();
end;
insert into p_sec_obj (SEC_OBJ) VALUES ('aaa');
fails saying sec_obj_pk not set - even tried removing getseq to a constant - same problem. Doesn't look like trigger is firing at all.
Subject
Written By
Posted
Does Falcon support triggers - or should I be worried
April 06, 2009 03:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.