{"id":15118,"date":"2017-09-15T13:34:09","date_gmt":"2017-09-15T16:34:09","guid":{"rendered":"http:\/\/orabr.com\/?p=15118"},"modified":"2017-09-15T13:42:58","modified_gmt":"2017-09-15T16:42:58","slug":"r12-como-remover-template-e-data-definition-no-xml-publisher","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=15118","title":{"rendered":"R12 COMO REMOVER TEMPLATE E DATA DEFINITION NO XML PUBLISHER"},"content":{"rendered":"

Via delete em tabela.<\/strong><\/p>\n

begin
\ndelete \u00a0 from XDO_TEMPLATES_B\u00a0 \u00a0 \u00a0 \u00a0 where template_code\u00a0 \u00a0 = ‘C\u00d3DIGO DO TEMPLATE’;
\ndelete \u00a0 from XDO_TEMPLATES_TL \u00a0 \u00a0 \u00a0 where template_code\u00a0 \u00a0 = ‘C\u00d3DIGO DO TEMPLATE’;
\ndelete \u00a0 from xdo_lobs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 where lob_code \u00a0 \u00a0 \u00a0 \u00a0 = ‘C\u00d3DIGO DO TEMPLATE’;
\ndelete \u00a0 from XDO_DS_DEFINITIONS_TL\u00a0 where data_source_code = ‘C\u00d3DIGO DA DEFINICAO DOS DADOS’;
\ndelete \u00a0 from XDO_DS_DEFINITIONS_b \u00a0 where data_source_code = ‘C\u00d3DIGO DA DEFINICAO DOS DADOS’;
\nend;<\/p>\n

Via\u00a0API CORE<\/strong><\/p>\n

Datadefinition<\/p>\n

BEGIN
\nXDO_DS_DEFINITIONS_PKG.DELETE_ROW(\u2018XX\u2019,\u2019C\u00d3DIGO DA DEFINICAO DOS DADOS\u2019);
\nEND;<\/p>\n

Template<\/p>\n

BEGIN
\nXDO_TEMPLATES_PKG.DELETE_ROW(\u2018XX\u2019,\u2019C\u00d3DIGO DO TEMPLATE\u2019);
\nEND;<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"

Via delete em tabela. begin delete \u00a0 from XDO_TEMPLATES_B\u00a0 \u00a0 \u00a0 \u00a0 where template_code\u00a0 \u00a0 = ‘C\u00d3DIGO DO TEMPLATE’; delete \u00a0 from XDO_TEMPLATES_TL \u00a0 \u00a0… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,127,124,126],"tags":[],"class_list":["post-15118","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-applications","category-database","category-developer-tools"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15118"}],"version-history":[{"count":2,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15118\/revisions"}],"predecessor-version":[{"id":15120,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15118\/revisions\/15120"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}