
/*------ ATD 355254 ------*/
-- Adicionando registro na tabela CONTROLEDEOBJETOS
DECLARE v_count NUMBER(1) := 0; 
BEGIN 
SELECT COUNT(1) INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = 'CONTROLEDEOBJETOS' AND Upper(column_name) = 'CHAVE'; 
IF v_count = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE CONTROLEDEOBJETOS ADD CHAVE VARCHAR(100)'; 
END IF;
END;
