Hi, i'm trying to create triggers for relational tables and have some problems ..
the 'END;' seems to fail throwing "ORA-00900: invalid SQL statement" ... but the statements before that succeeded according to status after i execute ... Is there a way to confirm if triggers are created and ignore the error?
Code:
CREATE TRIGGER TRI_ADDRESS_ADDID BEFORE INSERT ON ADDRESS
FOR EACH ROW
BEGIN
SELECT SEQ_ADDRESS_ADDID.NEXTVAL
INTO :NEW.ADDID
FROM DUAL;
END;the 'END;' seems to fail throwing "ORA-00900: invalid SQL statement" ... but the statements before that succeeded according to status after i execute ... Is there a way to confirm if triggers are created and ignore the error?
