SQL & PL/SQL

Hi Grus,
How can i write the trigger for Global Temporary Table.

I was created the GTT with trigger using the below script .


CREATE GLOBAL TEMPORARY TABLE GLOBAL_TEMP
(
EMP_C_NAME VARCHAR2(20 BYTE)
)
ON COMMIT PRESERVE ROWS;


CREATE OR REPLACE TRIGGER TRI_GLOBAL_TEMP
BEFORE DELETE OR UPDATE OR INSERT
ON GLOBAL_TEMP
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
INSERT INTO EMPNAME VALUES (:OLD.EMP_C_NAME);
END;
/


trigger was create successfully, but the wouldn't insert into to EMPNAME Table..

Please guide whether am correct or not? if not kindly give a correct syntax with example


Thanks in Advance,
Arun M M