Xml records from the database

[shree909]

Hi,

i have an oracle database with xml data.

with qv i want to extract the xml data and generate qvds and build the front end desgn

but the issue is i am able to connect to the database,

once i select the sql query the window closes

..

what i  know is that the data in the data base is xml so

by using qlikview we can read the xml data or not?

when i am loading the xml data it throws an error which is attached as an image

[shree909]

Hi can anyone help me on this???????????

[#3]

Did you ever get an answer to this question?

[#4]

Did you ever get an answer to this question?

[#5]

Did you ever get an answer to this question?

[shree909]

Hi,

i talked to our  database team and converted the xml  data into  normal data like varchar instead of XML ..

[#7]

Thanks for the response, unfortunately I am stuck with xml type.

[#8]

Hello to all.

I am also the problem of extracting information from an Oracle table with column of type XMLType. If anyone has any suggestions please help.

-------------------------------------------------------- Português ---------------------------------------------------------

Olá a todos.

Também estou com este problema de extrair informações de uma tabela Oracle com campo do tipo XMLTYPE. Caso alguém tenha alguma sugestão favor contribuir.

[#9]

Friends, I think I resolved my issue as follows:

In the script created a QlikView QVD:

SQL SELECT extract(XML_DOCUMENTO,'/','xmlns="http://www.portalfiscal.inf.br/cte"').getClobVal() AS XML_DOCUMENTO

FROM XML_DOCUMENTO_FISCAL

This way the files were extracted and can work with the data to make the load of the QVD created.

I hope have helped.

P.S.: Please forgive my English.

---------------------------------------------------------- Português ----------------------------------------------------------

Senhores, acho que resolvi minha questão da seguinte forma:

No script do QlikView criei um QVD:

SQL SELECT extract(XML_DOCUMENTO,'/','xmlns="http://www.portalfiscal.inf.br/cte"').getClobVal() AS XML_DOCUMENTO

FROM XML_DOCUMENTO_FISCAL

Desta forma os arquivos foram extraídos e consigo trabalhar com os dados ao fazer o load do qvd criado.

Espero ter ajudado.