Oracle Web ADI Interface Column Datatype Update Query

After Web ADI Interface has been defined we can not change Attribute datatype which is extracted from PLSQL procedure. Sometime required to update Interface attribute datatype from backend. Following Query is useful.

-----Data Type----------
Number - 1,
varchar - 2,
date   - 3

-------Query 1----------

update bne_interface_cols_b
set
data_type=3
where
interface_col_name like 'P_ATTRIBUTE_LINE4' and INTERFACE_CODE='XXAPINVCREATE_XINTG_INTF1';


--------Query2---------------

update bne_attributes
set ATTRIBUTE2='VARCHAR2'
where
ATTRIBUTE1 like 'P_SEGMENT%' and
ATTRIBUTE_CODE like 'XXAPINV3_XINTG_UPL1%'
;




Many case following solution not work, so you have to find another workaround.