DBA Data[Home] [Help]

APPS.ADX_PRF_PKG dependencies on USER_TAB_COLUMNS

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))';