CREATE TRIGGER TRIGGER_BIGDATA_TWEET_FILTER
BEFORE INSERT
ON BIGDATA_TWEET
FOR EACH ROW
AS
BEGIN
FOR _VALUE IN SELECT PRHB_VALUE FROM BIGDATA_TWEET_WORD_FILTER WHERE TYPE = 'username'
LOOP
IF _VALUE = NEW.USER_NAME THEN
INSERT INTO BIGDATA_TWEET_FILTER_APPLY (CREATED_DTTM, "text", USER_NAME, FILTER_TYPE, FILTER_WORD) VALUES (NEW.CREATED_DTTM, NEW."text", NEW.USER_NAME, 'U', _VALUE);
RETURN NULL;
END IF;
END LOOP;
FOR _VALUE in SELECT PRHB_VALUE FROM BIGDATA_TWEET_WORD_FILTER WHERE TYPE = 'word'
LOOP
_POS = position(_VALUE in NEW."text");
IF _POS > 0 THEN
INSERT INTO BIGDATA_TWEET_FILTER_APPLY (CREATED_DTTM, TEXT, USER_NAME, FILTER_TYPE, FILTER_WORD) VALUES (NEW.CREATED_DTTM, NEW."text", NEW.USER_NAME, 'W', _VALUE);
RETURN NULL;
END IF;
END LOOP;
RETURN NEW;
END
/
일단 7번째라인에서 #200705, SQL syntax error라고 나오는데...
원인을 도저히 모르겠네요..도와주시면감사하겠습니다~