XML or BI publisher template and data Definition deletion or Removal

最新推荐文章于 2024-11-11 11:50:39 发布

chisky

最新推荐文章于 2024-11-11 11:50:39 发布

阅读量929

点赞数 1

分类专栏： EBS 相关文章标签： xml bi templates

EBS 相关专栏收录该内容

19 篇文章 0 订阅

订阅专栏

From http://sivakandigatla.blogspot.com/2011/07/xml-or-bi-publisher-template-and-data.html

select * from XDO_TEMPLATES_B where template_code = :p_template_code
select * from XDO_TEMPLATES_TL where template_code = :p_template_code
select * from XDO_LOBS where lob_code = :p_template_code
select * from XDO_DS_DEFINITIONS_TL where data_source_code = :p_template_code
select * from XDO_DS_DEFINITIONS_B where data_source_code = :p_template_code

declare
p_template_code XDO_TEMPLATES_B.template_code%type := 'XXGRREP' ;
begin
delete from XDO_TEMPLATES_B where template_code = :p_template_code
delete from XDO_TEMPLATES_TL where template_code = :p_template_code
delete from xdo_lobs where lob_code = :p_template_code
delete from XDO_DS_DEFINITIONS_TL where data_source_code = :p_template_code
delete from XDO_DS_DEFINITIONS_b where data_source_code = :p_template_code
end;