
/*------ ATD 366144 ------*/
DECLARE v_count NUMBER(1):=0;
BEGIN
SELECT count(*) INTO v_count FROM USER_TAB_COLUMNS WHERE table_name = 'ITEMCLICOMPLEMENTO' AND column_name = 'DESCRICAOTEMPORARIA';
IF v_count>0 then
EXECUTE IMMEDIATE 'ALTER TABLE ITEMCLICOMPLEMENTO MODIFY DESCRICAOTEMPORARIA VARCHAR(100)';
END IF;
END;
