
/*------ ATD 407357 ------*/
DECLARE v_count NUMBER(1) := 0;   
BEGIN   
SELECT 1 INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = 'COMPLEMENTOPRODUTO' AND Upper(column_name) = 'Bloqueiadescformapgto';   
EXCEPTION   WHEN NO_DATA_FOUND THEN   
EXECUTE IMMEDIATE 'ALTER TABLE COMPLEMENTOPRODUTO ADD Bloqueiadescformapgto NUMBER(1,0)';
END;
/