Sifno je obelezje u tabeli clanak koje je references na radnik(sifrad).
Code:
CREATE OR REPLACE TRIGGER radnik_trigger
BEFORE INSERT OR UPDATE OF sifno ON clanak
FOR EACH ROW
BEGIN
IF
:NEW.sifno NOT IN (SELECT sifrad FROM radnik WHERE funk=1)
THEN
RAISE_APPLICATION_ERROR (-20001, 'Greska! Unos nije moguc');
END IF;
END;
CREATE OR REPLACE TRIGGER radnik_trigger
BEFORE INSERT OR UPDATE OF sifno ON clanak
FOR EACH ROW
BEGIN
IF
:NEW.sifno NOT IN (SELECT sifrad FROM radnik WHERE funk=1)
THEN
RAISE_APPLICATION_ERROR (-20001, 'Greska! Unos nije moguc');
END IF;
END;
Greska je sledeca:
Code:
LINE/COL ERROR
-------- -----------------------------------------------
2/3 PL/SQL: Statement ignored
3/23 PLS-00405: subquery not allowed in this context
LINE/COL ERROR
-------- -----------------------------------------------
2/3 PL/SQL: Statement ignored
3/23 PLS-00405: subquery not allowed in this context
Da li moze ovo nekako drugacije da se resi?