Hi all,
I'm trying to generate an xml file from a sql query onto Oracle 8.1.7 tables (via PL/SQL procedure).
I have a problem. I read your news on xml file generation.
I have tried to use xmlgen and dbms_xmlquery, but I haven't found a way to set more than one attribute for a node.
For example, I want to have:
<Contract IDContract = 'XXX' IDCustomer = 'YYY'>
But I don't know to to get this.
(Another problem I have is to write the <!DOCTYPE...> tag in the resulting xml file).
Any kind of suggestion on these two problems will be particularly appreciated.
Thank you in advance for any kind of help!
Natascia.
I'm trying to generate an xml file from a sql query onto Oracle 8.1.7 tables (via PL/SQL procedure).
I have a problem. I read your news on xml file generation.
I have tried to use xmlgen and dbms_xmlquery, but I haven't found a way to set more than one attribute for a node.
For example, I want to have:
<Contract IDContract = 'XXX' IDCustomer = 'YYY'>
But I don't know to to get this.
(Another problem I have is to write the <!DOCTYPE...> tag in the resulting xml file).
Any kind of suggestion on these two problems will be particularly appreciated.
Thank you in advance for any kind of help!
Natascia.