1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
CREATE OR REPLACE TRIGGER TOV_IN_SPIS
AFTER INSERT ON SMENA
DECLARE
RESULTAT DATE;
CURSOR c1 IS SELECT KOD, KOLICHESTVO, SUBSTR(SROK_GODNOSTI,3,2) AS BUKVA, DATA_IZGOTOVLENIA AS DATA_D, CAST(SUBSTR(SROK_GODNOSTI,1,2) AS INT) AS CHISLO FROM TOVAR1;
BEGIN
FOR i IN c1 LOOP
IF(i.BUKVA = 'Г') THEN BEGIN
SELECT to_date(i.DATA_D, 'dd.mm.yyyy')
- NUMTOYMINTERVAL(i.CHISLO, 'year') INTO RESULTAT
FROM dual;
IF (RESULTAT<= SYSDATE) THEN BEGIN
INSERT INTO SPISANIE1(KOD_SPISANIE,KOD_TOVAR ,KOLICHESTVO,DATA_S ,PRIMECH) VALUES (ID_SPISANIE.NextVal, i.KOD,i.KOLICHESTVO, SYSDATE, 'ИСТЕК СРОК ГОДНОСТИ');END;
END IF;
-- END;
END;END IF;
IF (i.BUKVA = 'М') THEN BEGIN
SELECT to_date(i.DATA_D, 'dd.mm.yyyy')
- NUMTOYMINTERVAL(i.CHISLO, 'month') INTO RESULTAT
FROM dual;
IF (RESULTAT<= SYSDATE) THEN BEGIN
INSERT INTO SPISANIE1(KOD_SPISANIE,KOD_TOVAR ,KOLICHESTVO,DATA_S ,PRIMECH) VALUES (ID_SPISANIE.NextVal, i.KOD,i.KOLICHESTVO, SYSDATE, 'ИСТЕК СРОК ГОДНОСТИ');END;
END IF;
END;
ELSE BEGIN
SELECT to_date(i.DATA_D, 'dd.mm.yyyy')
- NUMTODSINTERVAL(i.CHISLO, 'day') INTO RESULTAT
FROM dual;
IF (RESULTAT<= SYSDATE) THEN BEGIN
INSERT INTO SPISANIE1(KOD_SPISANIE,KOD_TOVAR ,KOLICHESTVO,DATA_S ,PRIMECH) VALUES (ID_SPISANIE.NextVal, i.KOD,i.KOLICHESTVO, SYSDATE, 'ИСТЕК СРОК ГОДНОСТИ'); END;
END IF;
END;END IF; END LOOP;
END TOV_IN_SPIS;
Ошибка:
ORA-25001: cannot create this trigger type on this type of view
25001. 00000 - "cannot create this trigger type on this type of view"
*Cause: INSTEAD OF triggers can be created on any view which is not an
Editioning View, while BEFORE and AFTER triggers may only be
created on Editioning Views.
*Action: Change the trigger type to INSTEAD OF or change the view on which
you are attempting to create a DML trigger.
что это значит?
