Ler XML dentro do XML

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
Responder
Avatar do usuário
bessa_lucas
Rank: Programador Sênior
Rank: Programador Sênior
Mensagens: 55
Registrado em: Sex, 17 Out 2014 3:02 pm
Lucas Bessa
Analista de Sistemas

lucas.bessa@obers.com.br
lucas.bessa.ti@gmail.com

Olá pessoal,
Estou comunicando com uma API que me retorno o XML dentro do XML.

Selecionar tudo

<RESPOSTA><REGISTROS><REGISTRO><CODIGO>17</CODIGO><CHAVE_ACESSO>31170410556925000177550030000000171000000172</CHAVE_ACESSO><XML><?xml version="1.0" encoding="UTF-8"?>

<nfeProc versao="3.10" xmlns="http://www.portalfiscal.inf.br/nfe"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe versao="3.10" Id="NFe31170410556925000177550030000000171000000172"><ide><cUF>31</cUF><cNF>00000017</cNF><natOp>Venda de produção própria, efetuada fora do estab.</natOp><indPag>1</indPag><mod>55</mod><serie>3</serie><nNF>17</nNF><dhEmi>2017-04-19T14:52:45-03:00</dhEmi><tpNF>1</tpNF><idDest>1</idDest><cMunFG>3148004</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>2</cDV><tpAmb>2</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>1</indPres><procEmi>0</procEmi><verProc>vê 4.38.1</verProc></ide><emit><CNPJ>10556925000177</CNPJ><xNome>OBERS LTDA - EPP</xNome><xFant>OBERS SISTEMAS</xFant><enderEmit><xLgr>R OLEGARIO MACIEL</xLgr><nro>203</nro><xBairro>CENTRO</xBairro><cMun>3148004</cMun><xMun>Patos de Minas</xMun><UF>MG</UF><CEP>38700122</CEP><cPais>1058</cPais><xPais>Brasil</xPais><fone>3438183800</fone></enderEmit><IE>0011044140070</IE><CRT>3</CRT></emit><dest><CNPJ>10835058000109</CNPJ><xNome>NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xNome><enderDest><xLgr>R ZINHO BUENO</xLgr><nro>760</nro><xBairro>CENTRO</xBairro><cMun>3141207</cMun><xMun>Matutina</xMun><UF>MG</UF><CEP>38870000</CEP><cPais>1058</cPais><xPais>Brasil</xPais><fone>3436741048</fone></enderDest><indIEDest>1</indIEDest><IE>0011773850016</IE></dest><det nItem="1"><prod><cProd>2</cProd><cEAN/><xProd>Café Extra Forte 500g</xProd><NCM>09012100</NCM><CFOP>5103</CFOP><uCom>PC</uCom><qCom>12.0000</qCom><vUnCom>7.1500</vUnCom><vProd>85.80</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>12.0000</qTrib><vUnTrib>7.1500</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>18.11</vTotTrib><ICMS><ICMS20><orig>0</orig><CST>20</CST><modBC>3</modBC><pRedBC>61.11</pRedBC><vBC>33.37</vBC><pICMS>18.00</pICMS><vICMS>6.01</vICMS></ICMS20></ICMS><IPI><cSelo>0.00000</cSelo><cEnq>999</cEnq><IPINT><CST>51</CST></IPINT></IPI><PIS><PISNT><CST>06</CST></PISNT></PIS><COFINS><COFINSNT><CST>06</CST></COFINSNT></COFINS></imposto></det><det nItem="2"><prod><cProd>3</cProd><cEAN/><xProd>Café Extra Forte 250g</xProd><NCM>09012100</NCM><CFOP>5103</CFOP><uCom>PC</uCom><qCom>20.0000</qCom><vUnCom>3.6000</vUnCom><vProd>72.00</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>20.0000</qTrib><vUnTrib>3.6000</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>15.20</vTotTrib><ICMS><ICMS20><orig>0</orig><CST>20</CST><modBC>3</modBC><pRedBC>61.11</pRedBC><vBC>28.00</vBC><pICMS>18.00</pICMS><vICMS>5.04</vICMS></ICMS20></ICMS><IPI><cSelo>0.00000</cSelo><cEnq>999</cEnq><IPINT><CST>51</CST></IPINT></IPI><PIS><PISNT><CST>06</CST></PISNT></PIS><COFINS><COFINSNT><CST>06</CST></COFINSNT></COFINS></imposto></det><total><ICMSTot><vBC>61.37</vBC><vICMS>11.05</vICMS><vICMSDeson>0.00</vICMSDeson><vBCST>0.00</vBCST><vST>0.00</vST><vProd>157.80</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>157.80</vNF><vTotTrib>33.31</vTotTrib></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><dup><nDup>1</nDup><dVenc>2017-05-19</dVenc><vDup>157.80</vDup></dup></cobr><infAdic><infCpl>Vendedor: LEANDRO;Número da Pronta entrega: 42;Condição de pagamento: 30 dias;Total dos tributos (lei 12.741/2012) - Federais: 33,31</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="#NFe31170410556925000177550030000000171000000172"><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>jvHfRDAZb3LJw1mfLM57+hU6Tc0=</DigestValue></Reference></SignedInfo><SignatureValue>pNXlOA8ofZsb0EmfSGe1+vD98AQvN3Bl1l69qmgtPBNerHZdIciQeWr9WPu8KkCjKGA9uMhCFlWEDZrB75Cgd887P/YAVSDDbti2/XZ5fsIaO7Di6Jl/wcbHCdyEtOGm1qD/+L/f7jzzGrBPFc8Dx21LbD1siHg87b9MK7hvY/MainjMipry5T4ocONGnegR+U/NCdL771BHHZ9GHqi3XfBTf/TRKH9K+2iUwVn14HVSm0+FXFEywKkdxWGMm0D7shsbV678vpWagFP0Nj2IqvKP+e96JAA3PjhvwSjxpK1rB5w+LWb06krTe96j1tE1hgNTdt4fcaWJPiwNAhNV+Q==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIH5jCCBc6gAwIBAgIIbgpZgQMpIjUwDQYJKoZIhvcNAQELBQAwcDELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEUMBIGA1UEAxMLQUMgTElOSyBSRkIwHhcNMTcwNDA0MTg1MzE4WhcNMTgwNDA0MTg1MzE4WjCB1jELMAkGA1UEBhMCQlIxCzAJBgNVBAgTAk1HMRQwEgYDVQQHEwtTQU8gR09UQVJETzETMBEGA1UEChMKSUNQLUJyYXNpbDE2MDQGA1UECxMtU2VjcmV0YXJpYSBkYSBSZWNlaXRhIEZlZGVyYWwgZG8gQnJhc2lsIC0gUkZCMRYwFAYDVQQLEw1SRkIgZS1DTlBKIEExMRAwDgYDVQQLEwdBUiBMSU5LMS0wKwYDVQQDEyRDQUZFIFNBTyBHT1RBUkRPIExUREE6MTA1NTY5MjUwMDAxNzcwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCtzsqs3xZhCWkogY/eKy+NskUc5YsqCiuCzQUjmGoJDAEh19eoIzI88xq/lXqvEigGqrCCwFKkAi4QjPmB8iW7T5Y4vCqV2VugN6mJb9ZTS9a6aBQi9XwV8EhtrZOg1IOlYOhfwjc4fouCxN86qz7Zqtn2vo8w1qAL5QiV9lthIJCi/MQVb7fiVYDqrf83vm2EQYfl8EQm8dKCkeIE4eIdKzG+JfgYiwkJTmwqQOW4RbpeHdnCWl1z9mpxNOB4lFbf5e5RoqX+J8gsWKmLhAr+DItNahYSp8D/bW3ik2WnhqyYIs7bBVM6OhjL3isfhM9MxKuFnlCvDXE+E0GnmACZAgMBAAGjggMbMIIDFzAfBgNVHSMEGDAWgBRZjSwlbOHzHl26JiFegQkoZYXVqDAOBgNVHQ8BAf8EBAMCBeAwbgYDVR0gBGcwZTBjBgZgTAECATswWTBXBggrBgEFBQcCARZLaHR0cDovL3JlcG9zaXRvcmlvLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvYWMtbGluay1yZmItcGMtYTEucGRmMIH5BgNVHR8EgfEwge4wUKBOoEyGSmh0dHA6Ly9yZXBvc2l0b3Jpby5saW5rY2VydGlmaWNhY2FvLmNvbS5ici9hYy1saW5rcmZiL2xjci1hYy1saW5rcmZidjIuY3JsMFGgT6BNhktodHRwOi8vcmVwb3NpdG9yaW8yLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvbGNyLWFjLWxpbmtyZmJ2Mi5jcmwwR6BFoEOGQWh0dHA6Ly9yZXBvc2l0b3Jpby5pY3BicmFzaWwuZ292LmJyL2xjci9saW5rL2xjci1hYy1saW5rcmZidjIuY3JsMIGVBggrBgEFBQcBAQSBiDCBhTBSBggrBgEFBQcwAoZGaHR0cDovL3JlcG9zaXRvcmlvLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvYWMtbGlua3JmYnYyLnA3YjAvBggrBgEFBQcwAYYjaHR0cDovL29jc3AubGlua2NlcnRpZmljYWNhby5jb20uYnIwgbUGA1UdEQSBrTCBqoEgRklOQU5DRUlST0BDQUZFU0FPR09UQVJETy5DT00uQlKgGAYFYEwBAwKgDxMNVEFUSUFOQSBLSVJZVaAZBgVgTAEDA6AQEw4xMDU1NjkyNTAwMDE3N6A4BgVgTAEDBKAvEy0wNTAyMTk4MjAxNDQwNzA3NjY5MDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDCgFwYFYEwBAwegDhMMMDAwMDAwMDAwMDAwMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDAJBgNVHRMEAjAAMA0GCSqGSIb3DQEBCwUAA4ICAQAJqn4XeLFGghvDYvPCA3zvjR/YNZ2f5COvhYxGjOatE1hNXhBwKquFAHib1oLJ4nMZGiVlHskN+sG4xVTAWkO46rZqadJjJd1+BUPebRKVN3msgtaYqqhzn8EoN4QU5ZEDEWppvx6CErW3jJIXyIIwRLtxPEoCGaczAfMoqsuDUWyLQbny3DoQVYK7f0QWVymtJn8AT74fNeOxQc7/19roql6Z39N3EK6gJrJb/tZm4pWoDs8B1ThcGv6iQ5tRT5KBvwtUJciIYP2QvWQbNswzv04QiZMztIJ/yz4VJzkN829rKAYA2YNlrsU9ovjIAEq2PiIYBvAGPDpJaEsgn1k3roJdaVqvS1DyjsiFKFWq47/+YZsz5NNwHlrz1qz6/qTb3r8yZjD4z8RtZYtbb+BvcVGfcXKBVs0RRqHNVnVEdfFv7DBO0De9EZBNiiAKKNEsj+qJLvK51HcyeFS9nzBJsWSUz9TuXfeNQTGR+z23Mxzdd//g0dyevKwzGxim4c2n2DiuOs9iKxf1GvhNYOLvlf8Qw2U6+I9u7d9p6yAj3tMjjMQMDBnIzXRGfuz9qJ5HNSQYvdtChdvOvbnAjMsurtULiNN0+o2LzVtNCejaqgz+tk7DrxfWKU+skLK9jk8QniltwB32Eai8tdFwLTeSEoPv7uKRGGL3EtYx/Fz3gQ==</X509Certificate></X509Data></KeyInfo></Signature></NFe><protNFe versao="3.10"><infProt><tpAmb>2</tpAmb><verAplic>14.0.25</verAplic><chNFe>31170410556925000177550030000000171000000172</chNFe><dhRecbto>2017-04-19T14:50:14-03:00</dhRecbto><nProt>131170128665595</nProt><digVal>jvHfRDAZb3LJw1mfLM57+hU6Tc0=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc></XML></REGISTRO><REGISTRO><CODIGO>18</CODIGO><CHAVE_ACESSO>31170410556925000177550030000000181000000188</CHAVE_ACESSO><XML><?xml version="1.0" encoding="UTF-8"?>

<nfeProc versao="3.10" xmlns="http://www.portalfiscal.inf.br/nfe"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe versao="3.10" Id="NFe31170410556925000177550030000000181000000188"><ide><cUF>31</cUF><cNF>00000018</cNF><natOp>Venda de produção própria, efetuada fora do estab.</natOp><indPag>1</indPag><mod>55</mod><serie>3</serie><nNF>18</nNF><dhEmi>2017-04-19T14:52:50-03:00</dhEmi><tpNF>1</tpNF><idDest>1</idDest><cMunFG>3148004</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>8</cDV><tpAmb>2</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>1</indPres><procEmi>0</procEmi><verProc>vê 4.38.1</verProc></ide><emit><CNPJ>10556925000177</CNPJ><xNome>OBERS LTDA - EPP</xNome><xFant>OBERS SISTEMAS</xFant><enderEmit><xLgr>R OLEGARIO MACIEL</xLgr><nro>203</nro><xBairro>CENTRO</xBairro><cMun>3148004</cMun><xMun>Patos de Minas</xMun><UF>MG</UF><CEP>38700122</CEP><cPais>1058</cPais><xPais>Brasil</xPais><fone>3438183800</fone></enderEmit><IE>0011044140070</IE><CRT>3</CRT></emit><dest><CNPJ>71393490000181</CNPJ><xNome>NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xNome><enderDest><xLgr>R MAJOR OLIMPIO FRANCO</xLgr><nro>187</nro><xBairro>CENTRO</xBairro><cMun>3141207</cMun><xMun>Matutina</xMun><UF>MG</UF><CEP>38870000</CEP><cPais>1058</cPais><xPais>Brasil</xPais><fone>3436741194</fone></enderDest><indIEDest>1</indIEDest><IE>4128633270053</IE></dest><det nItem="1"><prod><cProd>3</cProd><cEAN/><xProd>Café Extra Forte 250g</xProd><NCM>09012100</NCM><CFOP>5103</CFOP><uCom>PC</uCom><qCom>12.0000</qCom><vUnCom>3.6300</vUnCom><vProd>43.56</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>12.0000</qTrib><vUnTrib>3.6300</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>9.20</vTotTrib><ICMS><ICMS20><orig>0</orig><CST>20</CST><modBC>3</modBC><pRedBC>61.11</pRedBC><vBC>16.94</vBC><pICMS>18.00</pICMS><vICMS>3.05</vICMS></ICMS20></ICMS><IPI><cSelo>0.00000</cSelo><cEnq>999</cEnq><IPINT><CST>51</CST></IPINT></IPI><PIS><PISNT><CST>06</CST></PISNT></PIS><COFINS><COFINSNT><CST>06</CST></COFINSNT></COFINS></imposto></det><det nItem="2"><prod><cProd>2</cProd><cEAN/><xProd>Café Extra Forte 500g</xProd><NCM>09012100</NCM><CFOP>5103</CFOP><uCom>PC</uCom><qCom>4.0000</qCom><vUnCom>7.1500</vUnCom><vProd>28.60</vProd><cEANTrib/><uTrib>PC</uTrib><qTrib>4.0000</qTrib><vUnTrib>7.1500</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>6.04</vTotTrib><ICMS><ICMS20><orig>0</orig><CST>20</CST><modBC>3</modBC><pRedBC>61.11</pRedBC><vBC>11.12</vBC><pICMS>18.00</pICMS><vICMS>2.00</vICMS></ICMS20></ICMS><IPI><cSelo>0.00000</cSelo><cEnq>999</cEnq><IPINT><CST>51</CST></IPINT></IPI><PIS><PISNT><CST>06</CST></PISNT></PIS><COFINS><COFINSNT><CST>06</CST></COFINSNT></COFINS></imposto></det><total><ICMSTot><vBC>28.06</vBC><vICMS>5.05</vICMS><vICMSDeson>0.00</vICMSDeson><vBCST>0.00</vBCST><vST>0.00</vST><vProd>72.16</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>72.16</vNF><vTotTrib>15.24</vTotTrib></ICMSTot></total><transp><modFrete>9</modFrete></transp><cobr><dup><nDup>1</nDup><dVenc>2017-05-19</dVenc><vDup>72.16</vDup></dup></cobr><infAdic><infCpl>Vendedor: Lucas;Número da Pronta entrega: 43;Condição de pagamento: 30 dias;Total dos tributos (lei 12.741/2012) - Federais: 15,24</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="#NFe31170410556925000177550030000000181000000188"><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>lhjfW9aNGl8Op16WVNmwICRjvnU=</DigestValue></Reference></SignedInfo><SignatureValue>ThEj+6ixOu4xbvAq3LF0Rc1s/5zfgUJQ8hcUvfjnwoE02Wt5tCG/dYk5gjtPnNL59NDwPwlOTte6sXudDd2wHovofAhGvcbQ91dTlf+JPSCL0Ra9H5IeobjxAqqN2k2FS/iwTHiDITyDwES6QkJ+jQqZJQ/BUK5+cCTmUC2nehUZt1T2NC0E3d6+/jkozffN6hXLLtaGXY/vMjanWr7x6r6CJZcsXPxmeJ8nc2JJ9VZswWRU6B38TbXe4OSL9TNl/hR+nmWwuybC5Q4TuADE1HtFAvScSGG5sxbW826zpLT3JM2CzliduKnJA+/+hkNbi75SEpqOCpWnObjfWyAacw==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIH5jCCBc6gAwIBAgIIbgpZgQMpIjUwDQYJKoZIhvcNAQELBQAwcDELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEUMBIGA1UEAxMLQUMgTElOSyBSRkIwHhcNMTcwNDA0MTg1MzE4WhcNMTgwNDA0MTg1MzE4WjCB1jELMAkGA1UEBhMCQlIxCzAJBgNVBAgTAk1HMRQwEgYDVQQHEwtTQU8gR09UQVJETzETMBEGA1UEChMKSUNQLUJyYXNpbDE2MDQGA1UECxMtU2VjcmV0YXJpYSBkYSBSZWNlaXRhIEZlZGVyYWwgZG8gQnJhc2lsIC0gUkZCMRYwFAYDVQQLEw1SRkIgZS1DTlBKIEExMRAwDgYDVQQLEwdBUiBMSU5LMS0wKwYDVQQDEyRDQUZFIFNBTyBHT1RBUkRPIExUREE6MTA1NTY5MjUwMDAxNzcwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCtzsqs3xZhCWkogY/eKy+NskUc5YsqCiuCzQUjmGoJDAEh19eoIzI88xq/lXqvEigGqrCCwFKkAi4QjPmB8iW7T5Y4vCqV2VugN6mJb9ZTS9a6aBQi9XwV8EhtrZOg1IOlYOhfwjc4fouCxN86qz7Zqtn2vo8w1qAL5QiV9lthIJCi/MQVb7fiVYDqrf83vm2EQYfl8EQm8dKCkeIE4eIdKzG+JfgYiwkJTmwqQOW4RbpeHdnCWl1z9mpxNOB4lFbf5e5RoqX+J8gsWKmLhAr+DItNahYSp8D/bW3ik2WnhqyYIs7bBVM6OhjL3isfhM9MxKuFnlCvDXE+E0GnmACZAgMBAAGjggMbMIIDFzAfBgNVHSMEGDAWgBRZjSwlbOHzHl26JiFegQkoZYXVqDAOBgNVHQ8BAf8EBAMCBeAwbgYDVR0gBGcwZTBjBgZgTAECATswWTBXBggrBgEFBQcCARZLaHR0cDovL3JlcG9zaXRvcmlvLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvYWMtbGluay1yZmItcGMtYTEucGRmMIH5BgNVHR8EgfEwge4wUKBOoEyGSmh0dHA6Ly9yZXBvc2l0b3Jpby5saW5rY2VydGlmaWNhY2FvLmNvbS5ici9hYy1saW5rcmZiL2xjci1hYy1saW5rcmZidjIuY3JsMFGgT6BNhktodHRwOi8vcmVwb3NpdG9yaW8yLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvbGNyLWFjLWxpbmtyZmJ2Mi5jcmwwR6BFoEOGQWh0dHA6Ly9yZXBvc2l0b3Jpby5pY3BicmFzaWwuZ292LmJyL2xjci9saW5rL2xjci1hYy1saW5rcmZidjIuY3JsMIGVBggrBgEFBQcBAQSBiDCBhTBSBggrBgEFBQcwAoZGaHR0cDovL3JlcG9zaXRvcmlvLmxpbmtjZXJ0aWZpY2FjYW8uY29tLmJyL2FjLWxpbmtyZmIvYWMtbGlua3JmYnYyLnA3YjAvBggrBgEFBQcwAYYjaHR0cDovL29jc3AubGlua2NlcnRpZmljYWNhby5jb20uYnIwgbUGA1UdEQSBrTCBqoEgRklOQU5DRUlST0BDQUZFU0FPR09UQVJETy5DT00uQlKgGAYFYEwBAwKgDxMNVEFUSUFOQSBLSVJZVaAZBgVgTAEDA6AQEw4xMDU1NjkyNTAwMDE3N6A4BgVgTAEDBKAvEy0wNTAyMTk4MjAxNDQwNzA3NjY5MDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDCgFwYFYEwBAwegDhMMMDAwMDAwMDAwMDAwMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDAJBgNVHRMEAjAAMA0GCSqGSIb3DQEBCwUAA4ICAQAJqn4XeLFGghvDYvPCA3zvjR/YNZ2f5COvhYxGjOatE1hNXhBwKquFAHib1oLJ4nMZGiVlHskN+sG4xVTAWkO46rZqadJjJd1+BUPebRKVN3msgtaYqqhzn8EoN4QU5ZEDEWppvx6CErW3jJIXyIIwRLtxPEoCGaczAfMoqsuDUWyLQbny3DoQVYK7f0QWVymtJn8AT74fNeOxQc7/19roql6Z39N3EK6gJrJb/tZm4pWoDs8B1ThcGv6iQ5tRT5KBvwtUJciIYP2QvWQbNswzv04QiZMztIJ/yz4VJzkN829rKAYA2YNlrsU9ovjIAEq2PiIYBvAGPDpJaEsgn1k3roJdaVqvS1DyjsiFKFWq47/+YZsz5NNwHlrz1qz6/qTb3r8yZjD4z8RtZYtbb+BvcVGfcXKBVs0RRqHNVnVEdfFv7DBO0De9EZBNiiAKKNEsj+qJLvK51HcyeFS9nzBJsWSUz9TuXfeNQTGR+z23Mxzdd//g0dyevKwzGxim4c2n2DiuOs9iKxf1GvhNYOLvlf8Qw2U6+I9u7d9p6yAj3tMjjMQMDBnIzXRGfuz9qJ5HNSQYvdtChdvOvbnAjMsurtULiNN0+o2LzVtNCejaqgz+tk7DrxfWKU+skLK9jk8QniltwB32Eai8tdFwLTeSEoPv7uKRGGL3EtYx/Fz3gQ==</X509Certificate></X509Data></KeyInfo></Signature></NFe><protNFe versao="3.10"><infProt><tpAmb>2</tpAmb><verAplic>14.0.25</verAplic><chNFe>31170410556925000177550030000000181000000188</chNFe><dhRecbto>2017-04-19T14:50:14-03:00</dhRecbto><nProt>131170128665596</nProt><digVal>lhjfW9aNGl8Op16WVNmwICRjvnU=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc></XML></REGISTRO><REGISTRO/></REGISTROS></RESPOSTA>
O problema é que na documentação da API, o xml está do tipo string, e eu queria retornar em clob.

já tentei de várias formas, mas sem sucesso.
Ao chegar no "FOR", recebo a seguinte mensagem

ORA-01706: o valor do resultado da função do usuário era grande demais
ORA-06512: em "OBERS.PKG_INTEGRACAO_VENDASEXTERNAS", line 2588
ORA-06512: em line 6

Selecionar tudo

     -- GERA O XML DO RETORNO
    doc := xmltype.createxml(envelope);
    
    -- ABRE O CURSOR PARA VERIFICAR QUANTIDADE DE CODIGOS RETORNADOS
    declare cursor listar_nfe
      is
      
    -- EXTRAI O VALOR DA TAG
      select
            extractvalue(VALUE(TAB_ID),'/REGISTRO/CODIGO')           id_nota_fiscal,
            extractvalue(VALUE(TAB_ID),'/REGISTRO/CHAVE_ACESSO') x_chave,
            --xmltype.createxml(extractvalue(VALUE(TAB_ID),'/REGISTRO/XML'))           x_xml,
            --char_to_clob(extractvalue(VALUE(TAB_ID),'/REGISTRO/XML'))           x_xml
            --extractvalue(VALUE(TAB_ID).getclobval(),'/REGISTRO/CHAVE_ACESSO') x_xml
            --xmltype(envelope.xml).extract('//REGISTRO/XML/text()').getStringVal()
            
            EXTRACTVALUE(xmltype(doc), '/REGISTRO/XML') 
          
            
            --extractvalue(value(tab_id), '/REGISTRO/XML/text()') x_xml
            --xmltype(t.xml).extract('//fax/text()').getStringVal() from mytab t
            --envelope.xmlval.extract('/REGISTRO/XML/text()').getClobVal()
            --SELECT REMOVE_ESPACOS_TAG(XCTECABECMSG.EXTRACT ('/*').GETCLOBVAL ()) INTO XCTECABECMSGCLOB FROM DUAL;
            --extractvalue(VALUE(TAB_ID),'/REGISTRO/XML') X_XML,
            
            --extractValue(doc,'/RESPOSTA/MESSAGE')                    ds_mensagem
        from
            TABLE(XMLSequence(extract(doc,'/RESPOSTA/REGISTROS/REGISTRO'))) TAB_ID;

    BEGIN
      FOR REC IN listar_nfe
        LOOP
          BEGIN
            
            arquivo := UTL_File.Fopen( 'DFE_DOWNLOAD', rec.x_chave||'-procNFe.xml' ,'w',32767);

             
            --texto := rec.x_xml.getclobval();
            texto := rec.x_xml;
            
        
            UTL_FILE.put_line ( arquivo, texto);
            UTL_File.Fclose(arquivo);
          END;
        END LOOP;
    END;
  
  END;
Avatar do usuário
dr_gori
Moderador
Moderador
Mensagens: 5024
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

Eu procurei pelo erro ORA-01706 e eu achei a seguinte dica

https://forums.oracle.com/forums/messag ... 2#10736122


Para versão a partir de 11.2.0.2, pode usar

Selecionar tudo

SELECT x.*
FROM test_xml t
   , XMLTable(
       '/*/record'
       passing t.xml_data
       columns
         test_3  clob path 'test_3'
     ) x
;

Selecionar tudo

Mas para versão mais antiga, (10, por exemplo), aí se usa o getClobVal.
SELECT dbms_xmlgen.convert(x.test_3.getClobVal(), 1) as test_3
FROM test_xml t
   , XMLTable(
       '/*/record'
       passing t.xml_data
       columns
         test_3  xmltype path 'test_3/text()'
     ) x
;
Espero que isso ajude. Se conseguiu, manda a solução pra gente :-o
dcp
Rank: Programador Júnior
Rank: Programador Júnior
Mensagens: 17
Registrado em: Ter, 17 Set 2013 11:02 am

Bom dia pessoal,
estou com uma pequena dúvida.
Tenho um xml aqui, mas não estou conseguindo retornar o valor do ipi <vIPI>, alguém poderia me ajudar. Não sei se é porque o valor dele é 0.0, mas eu testei mudar para uma outra coluna por ex; '<CST>' que fica no mesmo nivel do nó.

Selecionar tudo

select Extractvalue(VALUE(xmlNFE),'/det/imposto/IPI/IPITtrib/vIPI','xmlns="http://www.portalfiscal.inf.br/nfe"') vIPI
 from xml_nfe x,
             TABle(XMLSequence(extract(x.xml_xmltype,
                                       'nfeProc/NFe/infNFe/det',
                                       'xmlns="http://www.portalfiscal.inf.br/nfe"'))) xmlNFE

abaixo o xml

Selecionar tudo

<?xml version="1.0" encoding="UTF-8"?>
<nfeProc versao="3.10" xmlns="http://www.portalfiscal.inf.br/nfe">
<NFe xmlns="http://www.portalfiscal.inf.br/nfe">
<infNFe versao="3.10" Id="NFe35170304823980000183550010000349811009051927">
<ide>
<emit>
<dest>
<det nItem="1">
<prod>
<imposto>
<ICMS>
<IPI>
<cEnq>999</cEnq>
<IPITrib>
<CST>99</CST>
<vBC>0.00</vBC>
<pIPI>0.00</pIPI>
<vIPI>0.00</vIPI>
</IPITrib>
</IPI>
<PIS>
<COFINS>
</imposto>
</det>
<det nItem="2">
<det nItem="3">
<det nItem="4">
<det nItem="5">
<det nItem="6">
<det nItem="7">
<total>
<transp>
<cobr>
<infAdic>
<compra/>
</infNFe>
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#">
</NFe>
<protNFe versao="3.10">
</nfeProc>
dcp
Rank: Programador Júnior
Rank: Programador Júnior
Mensagens: 17
Registrado em: Ter, 17 Set 2013 11:02 am

Veja:
dcp escreveu:Bom dia pessoal,
estou com uma pequena dúvida.
Tenho um xml aqui, mas não estou conseguindo retornar o valor do ipi <vIPI>, alguém poderia me ajudar. Não sei se é porque o valor dele é 0.0, mas eu testei mudar para uma outra coluna por ex; '<CST>' que fica no mesmo nivel do nó e também não retornou nada.

Selecionar tudo

select Extractvalue(VALUE(xmlNFE),'/det/imposto/IPI/IPITtrib/vIPI','xmlns="http://www.portalfiscal.inf.br/nfe"') vIPI
 from xml_nfe x,
             TABle(XMLSequence(extract(x.xml_xmltype,
                                       'nfeProc/NFe/infNFe/det',
                                       'xmlns="http://www.portalfiscal.inf.br/nfe"'))) xmlNFE

abaixo o xml

Selecionar tudo

<?xml version="1.0" encoding="UTF-8"?>
<nfeProc versao="3.10" xmlns="http://www.portalfiscal.inf.br/nfe">
<NFe xmlns="http://www.portalfiscal.inf.br/nfe">
<infNFe versao="3.10" Id="NFe35170304823980000183550010000349811009051927">
<ide>
<emit>
<dest>
<det nItem="1">
<prod>
<imposto>
<ICMS>
<IPI>
<cEnq>999</cEnq>
<IPITrib>
<CST>99</CST>
<vBC>0.00</vBC>
<pIPI>0.00</pIPI>
<vIPI>0.00</vIPI>
</IPITrib>
</IPI>
<PIS>
<COFINS>
</imposto>
</det>
<det nItem="2">
<det nItem="3">
<det nItem="4">
<det nItem="5">
<det nItem="6">
<det nItem="7">
<total>
<transp>
<cobr>
<infAdic>
<compra/>
</infNFe>
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#">
</NFe>
<protNFe versao="3.10">
</nfeProc>
spernega
Rank: DBA Pleno
Rank: DBA Pleno
Mensagens: 232
Registrado em: Ter, 19 Jun 2007 2:12 pm
Localização: São Paulo - SP

boa tarde dcp,

fiz um teste aqui.

Selecionar tudo

/det/imposto/IPI/IPITtrib/vIPI',
Acho que tem um t a mais por isso não retorna nada, é com ose não achasse o caminho.

Selecionar tudo

/det/imposto/IPI/IPITrib/vIPI',
dcp
Rank: Programador Júnior
Rank: Programador Júnior
Mensagens: 17
Registrado em: Ter, 17 Set 2013 11:02 am

Muito obrigado.

realmente um T a mais :roll:
abraços
dcp
Rank: Programador Júnior
Rank: Programador Júnior
Mensagens: 17
Registrado em: Ter, 17 Set 2013 11:02 am

Bom dia pessoal :lol:

Estou com um problema em uma consulta de um xml já importado no meu banco de dados abaixo vou mostrar o que faz.

Selecionar tudo

  
  Select distinct x.xml_nfe_id, 
           Extractvalue(VALUE(xmlNFE),'//cProd') cprod,
           Extractvalue(VALUE(xmlNFE),'//cEAN') cEAN,
           Extractvalue(VALUE(xmlNFE),'//xProd') xprod,
           Extractvalue(VALUE(xmlNFE),'//NCM') NCM,

           --lote(med)
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/nLote','xmlns="http://www.portalfiscal.inf.br/nfe"') nLote,
           Nvl(Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/qLote','xmlns="http://www.portalfiscal.inf.br/nfe"'), 
           Extractvalue(VALUE(xmlNFE),'//qCom'))qLote,
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/dFab','xmlns="http://www.portalfiscal.inf.br/nfe"') dFab,
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/dVal','xmlns="http://www.portalfiscal.inf.br/nfe"') dVal,
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/vPMC','xmlns="http://www.portalfiscal.inf.br/nfe"') vPMC,
              
      from xml_nfe x,
           TABle(XMLSequence(EXTRACT(x.xml_xmltype,
                                     'nfeProc/NFe/infNFe/det',
                                     'xmlns="http://www.portalfiscal.inf.br/nfe"'))) xmlNFE
                                    
     where x.xml_nfe_id = 16
Aqui tenho um xml que possui 7 produtos, tenho um produto que possui 2 lotes diferentes, o problema é esse !!
consegui trazer os 2 lotes, mas os mesmos vem no mesmo registro conforme código abaixo

Selecionar tudo

  
         --lote(med)
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/nLote','xmlns="http://www.portalfiscal.inf.br/nfe"') nLote,
           Nvl(Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/qLote','xmlns="http://www.portalfiscal.inf.br/nfe"'), 
           Extractvalue(VALUE(xmlNFE),'//qCom'))qLote,
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/dFab','xmlns="http://www.portalfiscal.inf.br/nfe"') dFab,
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/dVal','xmlns="http://www.portalfiscal.inf.br/nfe"') dVal,
           Extractvalue(VALUE(xmlNFE),'/det/prod/med[*]/vPMC','xmlns="http://www.portalfiscal.inf.br/nfe"') vPMC,
   
Preciso fazer uma quebra para que o outro lote apareça em um registro diferente, vou mostrar o retorno e o produto no qual possui 2 lotes :!: .

Selecionar tudo

EX: 4	16	000000000000642276	00382906422767	ANTICORPO ANTI-HLA-DR V450 100 T RUO/GMP	30021229	80398598065767	1.0001.000	2018-02-082018-03-06	2019-11-302019-11-30	0.000.00

Selecionar tudo

xml_nfe_id =	16
cprod         =     000000000000642276
cean          =	00382906422767
xprod         = 	ANTICORPO ANTI-HLA-DR V450 100 T RUO/GMP	
ncm            =     30021229	
nlote          =      8039859 (dois lotes saem juntos) 8065767	
qlote          =      1.000   (Quantidades de cada lote ) 1.000	
dfab           =    2018-02-08 (Data de fabricação de cada lote) 2018-03-06	
dval           =     2019-11-30(Data de validade de cada lote) 2019-11-30	
vpmc         =     0.00 (Vsei lao  que é isso  de cada lote) 0.00
já usei no from a seguinte instrução abaixo, separando o lote do xmlnfe mas assim gera cartesiano :cry:

Selecionar tudo

from xml_nfe x,
             TABle(XMLSequence(extract(x.xml_xmltype,
                                       'nfeProc/NFe/infNFe/det',
                                       'xmlns="http://www.portalfiscal.inf.br/nfe"'))) xmlNFE,
             TABle(XMLSequence(EXTRACTVALUE(x.xml_xmltype,
                                       'nfeProc/NFe/infNFe/det/prod',
                                       'xmlns="http://www.portalfiscal.inf.br/nfe"')))  lote  
Aqui o meu xml no qual estou com problema detalhe para o <det nItem="6"> que tem dois <nLote>

Selecionar tudo

<?xml version="1.0"?>
<nfeProc xmlns="http://www.portalfiscal.inf.br/nfe" versao="3.10">
<NFe xmlns="http://www.portalfiscal.inf.br/nfe">
<infNFe versao="3.10" Id="NFe42180521551379002141550070000439241833120732">
<ide>
<emit>
<dest>
<entrega>
<det nItem="1">
<prod>
<cProd>000000000000340364</cProd>
<cEAN>00382903403646</cEAN>
<xProd>ANTICORPO CD19 PE SJ25C1 50 T RUO/GMP</xProd>
<NCM>30021229</NCM>
<CFOP>6108</CFOP>
<uCom>UN</uCom>
<qCom>1.0000</qCom>
<vUnCom>1218.3000000000</vUnCom>
<vProd>1218.30</vProd>
<cEANTrib>382903403646</cEANTrib>
<uTrib>UN</uTrib>
<qTrib>1.0000</qTrib>
<vUnTrib>1218.3000000000</vUnTrib>
<indTot>1</indTot>
<xPed>1-18935</xPed>
<med>
<nLote>7276698</nLote>
<qLote>1.000</qLote>
<dFab>2017-10-03</dFab>
<dVal>2019-08-31</dVal>
<vPMC>0.00</vPMC>
</med>
</prod>
<imposto>
<infAdProd>L./Q. 7276698 / 1.000 - 20190831</infAdProd>
</det>
<det nItem="2">
<prod>
<cProd>000000000000347344</cProd>
<cEAN>00382903473441</cEAN>
<xProd>ANTICORPO CD3 PERCP SK7 100 T RUO/GMP</xProd>
<NCM>30021229</NCM>
<CFOP>6108</CFOP>
<uCom>UN</uCom>
<qCom>1.0000</qCom>
<vUnCom>2586.3300000000</vUnCom>
<vProd>2586.33</vProd>
<cEANTrib>382903473441</cEANTrib>
<uTrib>UN</uTrib>
<qTrib>1.0000</qTrib>
<vUnTrib>2586.3300000000</vUnTrib>
<indTot>1</indTot>
<xPed>1-18935</xPed>
<med>
<nLote>8017907</nLote>
<qLote>1.000</qLote>
<dFab>2018-01-17</dFab>
<dVal>2019-09-30</dVal>
<vPMC>0.00</vPMC>
</med>
</prod>
<imposto>
<infAdProd>L./Q. 8017907 / 1.000 - 20190930</infAdProd>
</det>
<det nItem="3">
<prod>
<cProd>000000000000347747</cProd>
<cEAN>00382903477470</cEAN>
<xProd>ANTICORPO CD56 PE MY31 100 T RUO/GMP</xProd>
<NCM>30021229</NCM>
<CFOP>6108</CFOP>
<uCom>UN</uCom>
<qCom>1.0000</qCom>
<vUnCom>2074.8300000000</vUnCom>
<vProd>2074.83</vProd>
<cEANTrib>382903477470</cEANTrib>
<uTrib>UN</uTrib>
<qTrib>1.0000</qTrib>
<vUnTrib>2074.8300000000</vUnTrib>
<indTot>1</indTot>
<xPed>1-18935</xPed>
<med>
<nLote>8051660</nLote>
<qLote>1.000</qLote>
<dFab>2018-02-20</dFab>
<dVal>2020-01-31</dVal>
<vPMC>0.00</vPMC>
</med>
</prod>
<imposto>
<infAdProd>L./Q. 8051660 / 1.000 - 20200131</infAdProd>
</det>
<det nItem="4">
<prod>
<cProd>000000000000554657</cProd>
<cEAN>00382905546570</cEAN>
<xProd>TAMPAO PHARMINGEN STAIN BSA 500ML</xProd>
<NCM>38220090</NCM>
<CFOP>6108</CFOP>
<uCom>UN</uCom>
<qCom>5.0000</qCom>
<vUnCom>500.3400000000</vUnCom>
<vProd>2501.70</vProd>
<cEANTrib>382905546570</cEANTrib>
<uTrib>UN</uTrib>
<qTrib>5.0000</qTrib>
<vUnTrib>500.3400000000</vUnTrib>
<indTot>1</indTot>
<xPed>1-18935</xPed>
<med>
<nLote>7342525</nLote>
<qLote>5.000</qLote>
<dFab>2017-12-08</dFab>
<dVal>2019-12-25</dVal>
<vPMC>0.00</vPMC>
</med>
</prod>
<imposto>
<infAdProd>L./Q. 7342525 / 5.000 - 20191225</infAdProd>
</det>
<det nItem="5">
<prod>
<cProd>000000000000344563</cProd>
<cEAN>00382903445639</cEAN>
<xProd>ANTICORPO STEM CELL ENUMERATION KIT 50 T</xProd>
<NCM>30021229</NCM>
<CFOP>6108</CFOP>
<uCom>UN</uCom>
<qCom>1.0000</qCom>
<vUnCom>2868.0000000000</vUnCom>
<vProd>2868.00</vProd>
<cEANTrib>382903445639</cEANTrib>
<uTrib>UN</uTrib>
<qTrib>1.0000</qTrib>
<vUnTrib>2868.0000000000</vUnTrib>
<indTot>1</indTot>
<xPed>1-18935</xPed>
<med>
<nLote>7296964</nLote>
<qLote>1.000</qLote>
<dFab>2017-10-23</dFab>
<dVal>2019-09-30</dVal>
<vPMC>0.00</vPMC>
</med>
</prod>
<imposto>
<infAdProd>L./Q. 7296964 / 1.000 - 20190930</infAdProd>
</det>
<det nItem="6">
<prod>
<cProd>000000000000642276</cProd>
<cEAN>00382906422767</cEAN>
<xProd>ANTICORPO ANTI-HLA-DR V450 100 T RUO/GMP</xProd>
<NCM>30021229</NCM>
<CFOP>6108</CFOP>
<uCom>UN</uCom>
<qCom>2.0000</qCom>
<vUnCom>2205.0300000000</vUnCom>
<vProd>4410.06</vProd>
<cEANTrib>382906422767</cEANTrib>
<uTrib>UN</uTrib>
<qTrib>2.0000</qTrib>
<vUnTrib>2205.0300000000</vUnTrib>
<indTot>1</indTot>
<xPed>1-18935</xPed>
<med>
<nLote>8039859</nLote>
<qLote>1.000</qLote>
<dFab>2018-02-08</dFab>
<dVal>2019-11-30</dVal>
<vPMC>0.00</vPMC>
</med>
<med>
<nLote>8065767</nLote>
<qLote>1.000</qLote>
<dFab>2018-03-06</dFab>
<dVal>2019-11-30</dVal>
<vPMC>0.00</vPMC>
</med>
</prod>
<imposto>
<infAdProd>L./Q. 8039859 / 1.000 - 20191130 L./Q. 8065767 / 1.000 - 20191130</infAdProd>
</det>
<det nItem="7">
<prod>
<cProd>000000000000551478</cProd>
<cEAN>00382905514784</cEAN>
<xProd>HU ANTI-CD66C PE MAB 100TST B6.2/CD66</xProd>
<NCM>30021229</NCM>
<CFOP>6108</CFOP>
<uCom>UN</uCom>
<qCom>1.0000</qCom>
<vUnCom>1395.9300000000</vUnCom>
<vProd>1395.93</vProd>
<cEANTrib>382905514784</cEANTrib>
<uTrib>UN</uTrib>
<qTrib>1.0000</qTrib>
<vUnTrib>1395.9300000000</vUnTrib>
<indTot>1</indTot>
<xPed>1-18935</xPed>
<med>
<nLote>7306645</nLote>
<qLote>1.000</qLote>
<dFab>2017-11-02</dFab>
<dVal>2022-12-31</dVal>
<vPMC>0.00</vPMC>
</med>
</prod>
<imposto>
<infAdProd>L./Q. 7306645 / 1.000 - 20221231</infAdProd>
</det>
<total>
<transp>
<cobr>
<infAdic>
</infNFe>
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#">
</NFe>
<protNFe xmlns="http://www.portalfiscal.inf.br/nfe" versao="3.10">
</nfeProc>

Agradeço a todos pelo apoio :D
Responder
  • Informação
  • Quem está online

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