Script to delete Data Definition and Template

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;