Thursday 8 September 2016

How to delete datadefinition and Template



Script for deleting the datadefinition
————————————————>
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW(‘XX’,’XXHR_EUREH_GEOS_ERROR_REPORT’);
Commit;
END;
——————————————————–
——————————————————–
script for deleting the template
——————————————————>
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW(‘XX’,’XXHR_EUREH_GEOS_ERROR_REPORT’);
Commit;
END;

OR

declare
begin
delete   from XDO_TEMPLATES_B        where template_code    = <template_code>
delete   from XDO_TEMPLATES_TL       where template_code    = <template_code>
delete   from xdo_lobs               where lob_code         = <template_code>
delete   from XDO_DS_DEFINITIONS_TL  where data_source_code = <def_code>
delete   from XDO_DS_DEFINITIONS_b   where data_source_code = <def_code>
end;


Commit;