To delete Data definition and template from Back end for a BI Publisher report the following code must be used.
Script for deleting the datadefinition
————————————————>
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW(‘XX’,’XXHR_EUREH_GEOS_ERROR_REPORT’);
END;
——————————————————–
——————————————————–
script for deleting the template
——————————————————>
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW(‘XX’,’XXHR_EUREH_GEOS_ERROR_REPORT’);
END;
Need to commit after running the script
OR
run the following
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 = ‘data definition code’;
delete from XDO_DS_DEFINITIONS_b where data_source_code = ‘data definition code’;
end;