CREATE TABLE garant_predmetu (
id_ucitela NUMBER(3) PRIMARY KEY,
meno VARCHAR(15) NOT NULL,
priezvisko VARCHAR(30) NOT NULL,
titul VARCHAR(20),
pracovisko NUMBER (6) CONSTRAINT fk_gp REFERENCES pracov_kat(id_prac)
);
CREATE SEQUENCE seq_garant START WITH 1 INCREMENT BY 1 NOMINVALUE;
CREATE OR REPLACE TRIGGER gar_inc
BEFORE INSERT ON garant_predmetu
FOR EACH ROW
BEGIN
SELECT seq_garant.nextval INTO new.id_ucitela FROM dual;
END;
mne napriklad nechce zobrat ani tento trigger stale ked dam vlozit nejaku hodnotu mi vypise ze
SQL> INSERT INTO garant_predmetu(meno,priezvisko,titul,pracovisko) values('Tomas','Poklemba','Ing
3);
INSERT INTO garant_predmetu(meno,priezvisko,titul,pracovisko) values('Tomas','Poklemba','Ing.',3)
*
ERROR v riadku 1:
ORA-04098: trigger 'bb777bb.GAR_INC' is invalid and failed re-validation