Pessoal, boa noite!<\/p>\n
Deixo aqui uma dica para aqueles que querem facilitar a exclus\u00e3o do Data Template \/ Data Definition referente \u00e0 um Relat\u00f3rio XML Publisher, por exemplo.<\/p>\n
Basta executar o script abaixo, alterando os dois par\u00e2metros iniciais.<\/p>\n
SET SERVEROUTPUT ON\r\n\r\nDECLARE\r\n -- Altere os parametros abaixo conforme sua necessidade\r\n var_templateCode VARCHAR2(100) := 'NAME_TEMPLATE_CODE'; -- Template Code.\r\n boo_deleteDataDef BOOLEAN := TRUE; -- True\/False para excluir Data Def. associado.\r\nBEGIN\r\n\r\nFOR RS IN (SELECT T1.APPLICATION_SHORT_NAME TEMPLATE_APP_NAME\r\n , T1.DATA_SOURCE_CODE\r\n , T2.APPLICATION_SHORT_NAME DEF_APP_NAME\r\n FROM XDO_TEMPLATES_B T1\r\n , XDO_DS_DEFINITIONS_B T2\r\n WHERE T1.TEMPLATE_CODE = var_templateCode\r\n AND T1.DATA_SOURCE_CODE = T2.DATA_SOURCE_CODE) LOOP\r\n\r\n XDO_TEMPLATES_PKG.DELETE_ROW(RS.TEMPLATE_APP_NAME, var_templateCode);\r\n\r\n DBMS_OUTPUT.PUT_LINE('Template ' || var_templateCode || ' exclu\u00eddo.');\r\n\r\n IF boo_deleteDataDef THEN\r\n XDO_DS_DEFINITIONS_PKG.DELETE_ROW(RS.DEF_APP_NAME, RS.DATA_SOURCE_CODE);\r\n\r\n DBMS_OUTPUT.PUT_LINE('Data Definition ' || RS.DATA_SOURCE_CODE || ' excluido.');\r\n END IF;\r\nEND LOOP;\r\n\r\nDBMS_OUTPUT.PUT_LINE('Fa\u00e7a um COMMIT ou um ROLLBACK para finalizar a execu\u00e7\u00e3o!');\r\n\r\nEXCEPTION\r\n WHEN OTHERS THEN\r\n -- ROLLBACK;\r\n DBMS_OUTPUT.PUT_LINE('N\u00e3o \u00e9 poss\u00edvel excluir Template XML Publisher' || var_templateCode);\r\n DBMS_OUTPUT.PUT_LINE(substr(SQLERRM, 1, 200));\r\nEND;<\/pre>\n
\nAbra\u00e7o,
\nJ\u00fanio Vitor de Paula<\/p>\n","protected":false},"excerpt":{"rendered":"
Pessoal, boa noite! Deixo aqui uma dica para aqueles que querem facilitar a exclus\u00e3o do Data Template \/ Data Definition referente \u00e0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4],"tags":[100,99,101,102,622,98],"class_list":["post-561","post","type-post","status-publish","format-standard","hentry","category-oracle","category-tecnologia","tag-bi","tag-bi-publisher","tag-delete-dt","tag-df","tag-oracle","tag-xml"],"_links":{"self":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/561"}],"collection":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=561"}],"version-history":[{"count":16,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/561\/revisions"}],"predecessor-version":[{"id":577,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/561\/revisions\/577"}],"wp:attachment":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}