
/*------ ATD 396677 ------*/
DECLARE v_count NUMBER(1) := 0; 

BEGIN 

SELECT 1 INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = 'PediCliComplemento' AND Upper(column_name) = 'ViaImpressao'; 

EXCEPTION 

WHEN NO_DATA_FOUND THEN 

EXECUTE IMMEDIATE 'ALTER TABLE PediCliComplemento ADD ViaImpressao integer default 0 not null '; 

END;