O arquivo que esta sendo gravado no xml esta com erro

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc
Responder
tchuck
Rank: Analista Júnior
Rank: Analista Júnior
Mensagens: 70
Registrado em: Seg, 04 Dez 2006 9:22 am
Localização: Maringá

Estou fazendo uma importação de uma nfe xml do fornecedor.
Consigo importar o arquivo de uma pasta do windows, coloco ele em um campo OLE_CONTAINER.
consigo trazer ele pro forms (Dou dois cliques nele e ele abre o XML corretamente) e o campo no forms também esta com OLE CONTAINER - campo basetable

Mas o problema é que quando eu salvo ele no banco, ele esta dando erro para leitura (esta corrompendo o arquivo), achei que poderia ser alguma sujeira no xml , mas tentei salvar uma imagem e também não obtive sucesso.
dou um select na tabela e está lá o arquivo como BLOB mas eu tento abrir ele com um programa que eu tenho q abre campos blob e não abre.

O campo da tabela esta em BLOB e do Forms esta em OLE CONTAINER, será que é este o problema?

Alguém já teve este problema? No forms eu vi que está trazendo correto, mas está corrompendo quando salvo no banco.
Avatar do usuário
dr_gori
Moderador
Moderador
Mensagens: 5023
Registrado em: Seg, 03 Mai 2004 3:08 pm
Localização: Portland, OR USA
Contato:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Hmmm... normalmente pra arquivos XML a gente usa um campo tipo CLOB.
Tem algum motivo de ser BLOB ?
tchuck
Rank: Analista Júnior
Rank: Analista Júnior
Mensagens: 70
Registrado em: Seg, 04 Dez 2006 9:22 am
Localização: Maringá

Tentei também com CLOB e não deu do mesmo jeito.
Continua com o arquivo corrompido.
Avatar do usuário
dr_gori
Moderador
Moderador
Mensagens: 5023
Registrado em: Seg, 03 Mai 2004 3:08 pm
Localização: Portland, OR USA
Contato:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Você já tentou comparar os 2 xml pra ver se tem alguma coisa diferente ?
(pra ver se ele foi carregado inteiro, etc)
tchuck
Rank: Analista Júnior
Rank: Analista Júnior
Mensagens: 70
Registrado em: Seg, 04 Dez 2006 9:22 am
Localização: Maringá

não sei o que pode estar acontecendo, peguei um arquivo de teste que existe aqui no forum (ANEXAR DOCTO NO FORMS.FMB) e fiz a mesma coisa, até testei com o próprio Programa, criei as tabelas de testes, fiz isto com varias versoes do banco, na versao de teste que tenho aqui utilizo o Banco 11g, na producao utilizo o 10g, e testei em uma outra empresa que presto serviço e também está com o mesmo erro, corrompendo o arquivo quando grava no banco.
Vou colocar um exemplo de xml aqui q estou tentando gravar e o que ele esta gravando no banco.

Selecionar tudo

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><nfeProc versao="2.00" xmlns:ns2="http://www.w3.org/2000/09/xmldsig#" xmlns="http://www.portalfiscal.inf.br/nfe"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41130478340270000210550000000944441000021544" versao="2.00"><ide><cUF>41</cUF><cNF>00002154</cNF><natOp>REMESSA P/CONSERTO</natOp><indPag>2</indPag><mod>55</mod><serie>0</serie><nNF>94444</nNF><dEmi>2013-04-01</dEmi><dSaiEnt>2013-04-01</dSaiEnt><hSaiEnt>09:11:08</hSaiEnt><tpNF>1</tpNF><cMunFG>4124608</cMunFG><tpImp>2</tpImp><tpEmis>1</tpEmis><cDV>4</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><procEmi>0</procEmi><verProc>2.00</verProc></ide><emit><CNPJ>78340270000210</CNPJ><xNome>COOPCANA - COOP. AGRIC. REG. DE PROD. DE CANA LTDA.</xNome><xFant>DESTILARIA - são CARLOS DO IVAI</xFant><enderEmit><xLgr>ROD. PR 559 - KM 06</xLgr><nro>S/N</nro><xCpl>ZONA RURAL</xCpl><xBairro>JURANDA</xBairro><cMun>4124608</cMun><xMun>são CARLOS DO IVAI</xMun><UF>PR</UF><CEP>87770000</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>4434388000</fone></enderEmit><IE>7250029807</IE><CRT>3</CRT></emit><dest><CNPJ>03416863000132</CNPJ><xNome>CALIBRATEC COM. E CALIBRACOES INSTRUMENTOS MEDICAO LTDA.</xNome><enderDest><xLgr>TRAV OTAVIO RIBAS GUIMARAES</xLgr><nro>N91</nro><xBairro>PORTAO</xBairro><cMun>4106902</cMun><xMun>CURITIBA</xMun><UF>PR</UF><CEP>80320150</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>4133450922</fone></enderDest><IE>9020910094</IE></dest><det nItem="1"><prod><cProd>5051</cProd><cEAN/><xProd>RELOGIO COMPARADOR MARCA MITUTOYO REF. 7019-B - LEITURA 0,01MM.</xProd><NCM>90318099</NCM><CFOP>5915</CFOP><uCom>PC</uCom><qCom>1.0000</qCom><vUnCom>500.0000000000</vUnCom><vProd>500.00</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>1.0000</qTrib><vUnTrib>500.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>50</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISOutr><CST>49</CST><vBC>0</vBC><pPIS>0</pPIS><vPIS>0</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>49</CST><vBC>0</vBC><pCOFINS>0</pCOFINS><vCOFINS>0</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</vICMS><vBCST>0.00</vBCST><vST>0.00</vST><vProd>500.00</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vPIS>0.00</vPIS><vCOFINS>0.00</vCOFINS><vOutro>0.00</vOutro><vNF>500.00</vNF></ICMSTot></total><transp><modFrete>0</modFrete></transp><infAdic><infCpl>EQUIPAMENTO PARA CONSERTO COM POSTERIOR RETORNO. ICMS SUSPENSO CFE ART. 105 ITEM VII DO DECRETO 6.080/12 DO RICMS-PR</infCpl></infAdic></infNFe><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#NFe41130478340270000210550000000944441000021544"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><DigestValue>h/XsHUL1Lxthu5ifTGPdhmd2YAo=</DigestValue></Reference></SignedInfo><SignatureValue>2rgXHXD/xKQKPAMFXNy/+R35wrseYOBy4k1pmDA2z81ndHjwgycQqLZGr05UyxQiTBj6mZJiemqcbMJzT07TNwF36QuEjavH1WawptHvYMTv/hFJn7w6nVK+xfPdFFwtpqyzYKzEg5wgZuSs6Dd0FRVXqVLpb5OlptiS2BhGZ+3cvTiGZoa9nkeuP2AyNrFLlaeK3pXIz942tjBMC3jvR6xj5WBGCHyhavTf3t6oHxjuaF79GmAieSZQFyYDL0EMo5+Y1CV3eh8/fICXPMDg+CnZZbV8LQUMNet28Th9YCceUjhuEbsdWvsSMPVUxRm8KCcb3JglDsYTEYTt5/4ynQ==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIIFzCCBf+gAwIBAgIIQR3pwrWuBa8wDQYJKoZIhvcNAQELBQAwdTELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEZMBcGA1UEAxMQQUMgU0VSQVNBIFJGQiB2MjAeFw0xMjEyMjAxNjA0MDBaFw0xMzEyMjAxNjA0MDBaMIH5MQswCQYDVQQGEwJCUjELMAkGA1UECBMCUFIxGTAXBgNVBAcTEFBBUkFJU08gRE8gTk9SVEUxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEWMBQGA1UECxMNUkZCIGUtQ05QSiBBMTESMBAGA1UECxMJQVIgU0VSQVNBMUkwRwYDVQQDE0BDT09QRVJBVElWQSBBR1JJQ09MQSBSRUdJT05BTCBERSBQUk9EVVRPUkVTIERFIENBOjc4MzQwMjcwMDAwMTM5MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA6VHF63v6kkvKDweyScD+yNFThZElr2DAD8ztKCnXYinh5KQHSVSQ2NWDdaq1F9ZU1JrPEzYqbzukqvhn+lNoqEybRiUciX1f+vhcHWLM+0YOeMJNJGV37IuETrsT3YPccR1c9tPtPwfRXtKHZqNWws9F//bsyTxOK8R+SyWHRqyikJWkEuCMaSCbpSDDIiCMNymMFKWnQch2xoAhdgZkH8xQTmZXggelp0ne5deiDCXsW5FJrvLKWEL52AbkagVIh31ss8Uu40iJyiJRkfd94b48za4No9X54WPfvqLvmtDKvQq9wrC13NvCJ0zJWNBL954jc3Wb8GFCDBPMHekRgQIDAQABo4IDJDCCAyAwgZkGCCsGAQUFBwEBBIGMMIGJMEgGCCsGAQUFBzAChjxodHRwOi8vd3d3LmNlcnRpZmljYWRvZGlnaXRhbC5jb20uYnIvY2FkZWlhcy9zZXJhc2FyZmJ2Mi5wN2IwPQYIKwYBBQUHMAGGMWh0dHA6Ly9vY3NwLmNlcnRpZmljYWRvZGlnaXRhbC5jb20uYnIvc2VyYXNhcmZidjIwCQYDVR0TBAIwADAfBgNVHSMEGDAWgBSyoMQ9Rp58yIVsCB4QMpRlRnBBczBxBgNVHSAEajBoMGYGBmBMAQIBDTBcMFoGCCsGAQUFBwIBFk5odHRwOi8vcHVibGljYWNhby5jZXJ0aWZpY2Fkb2RpZ2l0YWwuY29tLmJyL3JlcG9zaXRvcmlvL2RwYy9kZWNsYXJhY2FvLXJmYi5wZGYwgfMGA1UdHwSB6zCB6DBKoEigRoZEaHR0cDovL3d3dy5jZXJ0aWZpY2Fkb2RpZ2l0YWwuY29tLmJyL3JlcG9zaXRvcmlvL2xjci9zZXJhc2FyZmJ2Mi5jcmwwRKBCoECGPmh0dHA6Ly9sY3IuY2VydGlmaWNhZG9zLmNvbS5ici9yZXBvc2l0b3Jpby9sY3Ivc2VyYXNhcmZidjIuY3JsMFSgUqBQhk5odHRwOi8vcmVwb3NpdG9yaW8uaWNwYnJhc2lsLmdvdi5ici9sY3IvU2VyYXNhL3JlcG9zaXRvcmlvL2xjci9zZXJhc2FyZmJ2Mi5jcmwwDgYDVR0PAQH/BAQDAgXgMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDCBvQYDVR0RBIG1MIGygRlESVJFVE9SSUFAQ09PUENBTkEuQ09NLkJSoCIGBWBMAQMCoBkTF0VMSUFTIEZFUk5BTkRPIFZJWlpPVFRPoBkGBWBMAQMDoBATDjc4MzQwMjcwMDAwMTM5oD0GBWBMAQMEoDQTMjA1MDYxOTU3Mzg4MDk1MDg5MDQxMjAwNzUyNjI3MzAwMDAwMDAwOTMwMDYzNVNFU1BSoBcGBWBMAQMHoA4TDDAwMDAwMDAwMDAwMDANBgkqhkiG9w0BAQsFAAOCAgEAQVVwGxmIUuqn5cnqI5xAeJ/KYbPTyxWZv16sTZbZKIf/dcBGCHnSU/Xqi+aDy6/PZOh9iVoQ5N2OdDTKoUpGntCrmMJIG63Mz04co4U4XHUMUm5LzFIshGedKNMkPYlHb4nJU06dnl5gB/MCBkbjFq4rVf8ftRtnLudtp2sPx6JG+Fof/nVaNM1iiB2/So7TlLVBVH4DdpdGgCG6tzkE97HgrS+noBTXp86sb/dkiTdlS8dhN4gDdm2kUj16KZVIvtTciPve/gTN8fn5bX/Q6g6FT7FNw6C/uMLct6+9Pzw9TvtXPdPf2ippJgyJZt2CJ288+0fqkZhwogl6idWnblD1H9Fcyi5Ah+HXpz+4XWFGBYYsGyHAxKHGp3dT+GExYQHH/+z93rsgG46nNQTs0Ar2CQXdij3SNxwUg3Yu7mUCAyIeps/U1aTT3BgsmQC7jK8WYMeh1HPNhv0t1nt5LLI/Vg3DDr36IG+3z2U6oQYe16S1ap40Nuklhf5rt0u9Yp2HpgAUU8Yq56H7UoRgnStb3PvmJXkj5u07UKO246QxUPaKELcyka8YJAdSKM07mpmJBaFHrPnDVLowxt2SXbOA02IXkVAb2D9LzHX/4qvo1RHP0Ra8m5Tr+5KKwW/mzZTaA83TParYYwZUovkHgrpy4AMHgRw0ws/WoFVpSfY=</X509Certificate></X509Data></KeyInfo></Signature></NFe><protNFe versao="2.00"><infProt><tpAmb>1</tpAmb><verAplic>PR-v2_6_9</verAplic><chNFe>41130478340270000210550000000944441000021544</chNFe><dhRecbto>2013-04-01T09:12:26</dhRecbto><nProt>141130044979008</nProt><digVal>h/XsHUL1Lxthu5ifTGPdhmd2YAo=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc>
e o que ele esta gravando.
Está corrompendo o começo do xml.

Selecionar tudo

ÐÏࡱáÿs>BRASIL</xPais><fone>4133450922</fone></enderDest><IE>9020910094</IE></dest><det nItem="1"><prod><cProd>5051</cProd><cEAN/><xProd>RELOGIO COMPARADOR MARCA MITUTOYO REF. 7019-B - LEITURA 0,01MM.</xProd><NCM>90318099</NCM><CFOP>5915</CFOP><uCom>PC</uCom><qCom>1.0000</qCom><vUnCom>500.0000000000</vUnCom><vProd>500.00</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>1.0000</qTrib><vUnTrib>500.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>50</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISOutr><CST>49</CST><vBC>0</vBC><pPIS>0</pPIS><vPIS>0</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>49</CST><vBC>0</vBC><pCOFINS>0</pCOFINS><vCOFINS>0</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</vICMS><vBCST>0.00</vBCST><vST>0.00</vST><vProd>500.00</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vPIS>0.00</vPIS><vCOFINS>0.00</vCOFINS><vOutro>0.00</vOutro><vNF>500.00</vNF></ICMSTot></total><transp><modFrete>0</modFrete></transp><infAdic><infCpl>EQUIPAMENTO PARA CONSERTO COM POSTERIOR RETORNO. ICMS SUSPENSO CFE ART. 105 ITEM VII DO DECRETO 6.080/12 DO RICMS-PR</infCpl></infAdic></infNFe><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#NFe41130478340270000210550000000944441000021544"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><DigestValue>h/XsHUL1Lxthu5ifTGPdhmd2YAo=</DigestValue></Reference></SignedInfo><SignatureValue>2rgXHXD/xKQKPAMFXNy/+R35wrseYOBy4k1pmDA2z81ndHjwgycQqLZGr05UyxQiTBj6mZJiemqcbMJzT07TNwF36QuEjavH1WawptHvYMTv/hFJn7w6nVK+xfPdFFwtpqyzYKzEg5wgZuSs6Dd0FRVXqVLpb5OlptiS2BhGZ+3cvTiGZoa9nkeuP2AyNrFLlaeK3pXIz942tjBMC3jvR6xj5WBGCHyhavTf3t6oHxjuaF79GmAieSZQFyYDL0EMo5+Y1CV3eh8/fICXPMDg+CnZZbV8LQUMNet28Th9YCceUjhuEbsdWvsSMPVUxRm8KCcb3JglDsYTEYTt5/4ynQ==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIIFzCCBf+gAwIBAgIIQR3pwrWuBa8wDQYJKoZIhvcNAQELBQAwdTELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEZMBcGA1UEAxMQQUMgU0VSQVNBIFJGQiB2MjAeFw0xMjEyMjAxNjA0MDBaFw0xMzEyMjAxNjA0MDBaMIH5MQswCQYDVQQGEwJCUjELMAkGA1UECBMCUFIxGTAXBgNVBAcTEFBBUkFJU08gRE8gTk9SVEUxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEWMBQGA1UECxMNUkZCIGUtQ05QSiBBMTESMBAGA1UECxMJQVIgU0VSQVNBMUkwRwYDVQQDE0BDT09QRVJBVElWQSBBR1JJQ09MQSBSRUdJT05BTCBERSBQUk9EVVRPUkVTIERFIENBOjc4MzQwMjcwMDAwMTM5MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA6VHF63v6kkvKDweyScD+yNFThZElr2DAD8ztKCnXYinh5KQHSVSQ2NWDdaq1F9ZU1JrPEzYqbzukqvhn+lNoqEybRiUciX1f+vhcHWLM+0YOeMJNJGV37IuETrsT3YPccR1c9tPtPwfRXtKHZqNWws9F//bsyTxOK8R+SyWHRqyikJWkEuCMaSCbpSDDIiCMNymMFKWnQch2xoAhdgZkH8xQTmZXggelp0ne5deiDCXsW5FJrvLKWEL52AbkagVIh31ss8Uu40iJyiJRkfd94b48za4No9X54WPfvqLvmtDKvQq9wrC13NvCJ0zJWNBL954jc3Wb8GFCDBPMHekRgQIDAQABo4IDJDCCAyAwgZkGCCsGAQUFBwEBBIGMMIGJMEgGCCsGAQUFBzAChjxodHRwOi8vd3d3LmNlcnRpZmljYWRvZGlnaXRhbC5jb20uYnIvY2FkZWlhcy9zZXJhc2FyZmJ2Mi5wN2IwPQYIKwYBBQUHMAGGMWh0dHA6Ly9vY3NwLmNlcnRpZmljYWRvZGlnaXRhbC5jb20uYnIvc2VyYXNhcmZidjIwCQYDVR0TBAIwADAfBgNVHSMEGDAWgBSyoMQ9Rp58yIVsCB4QMpRlRnBBczBxBgNVHSAEajBoMGYGBmBMAQIBDTBcMFoGCCsGAQUFBwIBFk5odHRwOi8vcHVibGljYWNhby5jZXJ0aWZpY2Fkb2RpZ2l0YWwuY29tLmJyL3JlcG9zaXRvcmlvL2RwYy9kZWNsYXJhY2FvLXJmYi5wZGYwgfMGA1UdHwSB6zCB6DBKoEigRoZEaHR0cDovL3d3dy5jZXJ0aWZpY2Fkb2RpZ2l0YWwuY29tLmJyL3JlcG9zaXRvcmlvL2xjci9zZXJhc2FyZmJ2Mi5jcmwwRKBCoECGPmh0dHA6Ly9sY3IuY2VydGlmaWNhZG9zLmNvbS5ici9yZXBvc2l0b3Jpby9sY3Ivc2VyYXNhcmZidjIuY3JsMFSgUqBQhk5odHRwOi8vcmVwb3NpdG9yaW8uaWNwYnJhc2lsLmdvdi5ici9sY3IvU2VyYXNhL3JlcG9zaXRvcmlvL2xjci9zZXJhc2FyZmJ2Mi5jcmwwDgYDVR0PAQH/BAQDAgXgMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDCBvQYDVR0RBIG1MIGygRlESVJFVE9SSUFAQ09PUENBTkEuQ09NLkJSoCIGBWBMAQMCoBkTF0VMSUFTIEZFUk5BTkRPIFZJWlpPVFRPoBkGBWBMAQMDoBATDjc4MzQwMjcwMDAwMTM5oD0GBWBMAQMEoDQTMjA1MDYxOTU3Mzg4MDk1MDg5MDQxMjAwNzUyNjI3MzAwMDAwMDAwOTMwMDYzNVNFU1BSoBcGBWBMAQMHoA4TDDAwMDAwMDAwMDAwMDANBgkqhkiG9w0BAQsFAAOCAgEAQVVwGxmIUuqn5cnqI5xAeJ/KYbPTyxWZv16sTZbZKIf/dcBGCHnSU/Xqi+aDy6/PZOh9iVoQ5N2OdDTKoUpGntCrmMJIG63Mz04co4U4XHUMUm5LzFIshGedKNMkPYlHb4nJU06dnl5gB/MCBkbjFq4rVf8ftRtnLudtp2sPx6JG+Fof/nVaNM1iiB2/So7TlLVBVH4DdpdGgCG6tzkE97HgrS+noBTXp86sb/dkiTdlS8dhN4gDdm2kUj16KZVIvtTciPve/gTN8fn5bX/Q6g6FT7FNw6C/uMLct6+9Pzw9TvtXPdPf2ippJgyJZt2CJ288+0fqkZhwogl6idWnblD1H9Fcyi5Ah+HXpz+4XWFGBYYsGyHAxKHGp3dT+GExYQHH/+z93rsgG46nNQTs0Ar2CQXdij3SNxwUg3Yu7mUCAyIeps/U1aTT3BgsmQC7jK8WYMeh1HPNhv0t1nt5LLI/Vg3DDr36IG+3z2U6oQYe16S1ap40Nuklhf5rt0u9Yp2HpgAUU8Yq56H7UoRgnStb3PvmJXkj5u07UKO246QxUPaKELcyka8YJAdSKM07mpmJBaFHrPnDVLowxt2SXbOA02IXkVAb2D9LzHX/4qvo1RHP0Ra8m5Tr+5KKwW/mzZTaA83TParYYwZUovkHgrpy4AMHgRw0ws/WoFVpSfY=</X509Certificate></X509Data></KeyInfo></Signature></NFe><protNFe versao="2.00"><infProt><tpAmb>1</tpAmb><verAplic>PR-v2_6_9</verAplic><chNFe>41130478340270000210550000000944441000021544</chNFe><dhRecbto>2013-04-01T09:12:26</dhRecbto><nProt>141130044979008</nProt><digVal>h/XsHUL1Lxthu5ifTGPdhmd2YAo=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc><kH8xQT
tchuck
Rank: Analista Júnior
Rank: Analista Júnior
Mensagens: 70
Registrado em: Seg, 04 Dez 2006 9:22 am
Localização: Maringá

Consegui resolver,

coloquei o campo no banco como LONG RAW. (para xml), para outros tipos de arquivo deve alterar o tipo. (blob) para pdf. e assim por diante.

Fiz por tentativa e erro. Mas no final deu certo.

Grava e consulto normalmente com os comandos.

Selecionar tudo

	  FORMS_OLE.ACTIVATE_SERVER('bloco.ole_xml');
  	FORMS_OLE.INITIALIZE_CONTAINER('bloco.ole_xml', FILENAME);
  	FORMS_OLE.CLOSE_SERVER('bloco.ole_xml');
Responder
  • Informação
  • Quem está online

    Usuários navegando neste fórum: Nenhum usuário registrado e 2 visitantes