-- 프로시저 생성 
CREATE OR REPLACE PROCEDURE MPSS_SBB."FNC_TWITTER_FILTER()" 
AS
_VALUE VARCHAR(50);
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
        SELECT INSTR ("NEW"."text",_VALUE) AS _POS;
        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; 
/
    

위소스에서...

ERROR를 도저히 찾을수가 없네요...ㅠㅠ

FOR _VALUE IN (SELECT PRHB_VALUE FROM BIGDATA_TWEET_WORD_FILTER WHERE TYPE = 'username') 요부분에서

#201032, Undefined identifier

이렇게나네요... 

가르침부탁드립니다!