Line 104: select column_name into columnname from user_tab_columns where table_name like 'ADX_PRE_AUTOCONFIG' and column_name like 'LEVEL_VALUE2';
100: declare
101: columnname varchar2(100);
102: begin
103: if (p_level_value2 is not NULL) then 104: select column_name into columnname from user_tab_columns where table_name like 'ADX_PRE_AUTOCONFIG' and column_name like 'LEVEL_VALUE2'; 105: end if;
106: exception WHEN NO_DATA_FOUND THEN
107: execute immediate 'alter table ADX_PRE_AUTOCONFIG
108: add (level_value2 varchar2(100))';