{"id":20405,"date":"2020-04-27T14:23:07","date_gmt":"2020-04-27T17:23:07","guid":{"rendered":"https:\/\/orabr.com\/?p=20405"},"modified":"2020-04-29T20:17:52","modified_gmt":"2020-04-29T23:17:52","slug":"-leitura-campo-blob-por-dblink-3","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=20405","title":{"rendered":"Leitura campo BLOB por DBLink."},"content":{"rendered":"

<\/p>\n

 <\/span> <\/p>\n
\n
<\/p>\n
\n

Boa tarde,<\/p>\n
Faz um create table as select * from table e traz os dados pra sua inst\u00e2ncia.<\/div>\n
Ai fica mais f\u00e1cil de tratar<\/div>\n<\/div>\n

<\/p>\n

\n
Em seg, 27 de abr de 2020 18:10, FelixDenilson felix.denilson@gmail.com<\/a> <<\/a>> escreveu:<\/div>\n

<\/u> <\/p>\n

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

Boa tarde Grupo.<\/p>\n

Algu\u00e9m teria um exemplo de como recuperar um campo BLOB de uma tabela que est\u00e1 em outro ambiente utilizando para isso um DBLink?
Estando no banco Oracle, preciso ler um campo IMAGEM da tabela xyz@dblink (ambiente APEX)\u00a0 e guardar no RI.\u00a0<\/p>\n

Vers\u00e3o R11.<\/p>\n

Obrigado,
Denilson <\/p>\n<\/p><\/div>\n

<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/blockquote>\n<\/div>\n<\/p><\/div>\n

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

  Boa tarde, Faz um create table as select * from table e traz os dados pra sua inst\u00e2ncia. Ai fica mais f\u00e1cil de tratar… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-20405","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/20405","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=20405"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/20405\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}