{"id":17483,"date":"2018-11-07T07:48:40","date_gmt":"2018-11-07T09:48:40","guid":{"rendered":"http:\/\/orabr.com\/?p=17483"},"modified":"2018-11-07T07:58:24","modified_gmt":"2018-11-07T09:58:24","slug":"como-ativar-examine-via-pl-sql-via-banco-dados-back-end","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=17483","title":{"rendered":"COMO ATIVAR EXAMINE\/DIAGN\u00d3STICO VIA PL\/SQL, VIA BANCO DADOS (BACK END)"},"content":{"rendered":"

BEGIN<\/p>\n

\u00a0 <\/span>IF FND_PROFILE.SAVE(X_NAME => ‘FND_DIAGNOSTICS’,\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/span><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>X_VALUE => ‘Y’,<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>X_LEVEL_NAME => ‘SITE’) THEN<\/p>\n

\u00a0 \u00a0 <\/span>DBMS_OUTPUT.PUT_LINE(‘Success’);<\/p>\n

\u00a0 <\/span>ELSE<\/p>\n

\u00a0 \u00a0 <\/span>DBMS_OUTPUT.PUT_LINE(‘Fail’);<\/p>\n

\u00a0 <\/span>END IF;<\/p>\n

\u00a0 <\/span>COMMIT;<\/p>\n

END;<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"

BEGIN \u00a0 IF FND_PROFILE.SAVE(X_NAME => ‘FND_DIAGNOSTICS’,\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \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],"tags":[],"class_list":["post-17483","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-applications","category-database"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17483","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=17483"}],"version-history":[{"count":2,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17483\/revisions"}],"predecessor-version":[{"id":17485,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17483\/revisions\/17485"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}