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;
No comments:
Post a Comment