5134:
5135: indoc VARCHAR2(2000);
5136: xsldoc VARCHAR2(2000);
5137: myParser dbms_xmlparser.Parser;
5138: indomdoc dbms_xmldom.domdocument;
5139: xsltdomdoc dbms_xmldom.domdocument;
5140: xsl dbms_xslprocessor.stylesheet;
5141: outdomdocf dbms_xmldom.domdocumentfragment;
5142: outnode dbms_xmldom.domnode;
5135: indoc VARCHAR2(2000);
5136: xsldoc VARCHAR2(2000);
5137: myParser dbms_xmlparser.Parser;
5138: indomdoc dbms_xmldom.domdocument;
5139: xsltdomdoc dbms_xmldom.domdocument;
5140: xsl dbms_xslprocessor.stylesheet;
5141: outdomdocf dbms_xmldom.domdocumentfragment;
5142: outnode dbms_xmldom.domnode;
5143: proc dbms_xslprocessor.processor;
5137: myParser dbms_xmlparser.Parser;
5138: indomdoc dbms_xmldom.domdocument;
5139: xsltdomdoc dbms_xmldom.domdocument;
5140: xsl dbms_xslprocessor.stylesheet;
5141: outdomdocf dbms_xmldom.domdocumentfragment;
5142: outnode dbms_xmldom.domnode;
5143: proc dbms_xslprocessor.processor;
5144: buf varchar2(2000);
5145: xmlclob clob;
5138: indomdoc dbms_xmldom.domdocument;
5139: xsltdomdoc dbms_xmldom.domdocument;
5140: xsl dbms_xslprocessor.stylesheet;
5141: outdomdocf dbms_xmldom.domdocumentfragment;
5142: outnode dbms_xmldom.domnode;
5143: proc dbms_xslprocessor.processor;
5144: buf varchar2(2000);
5145: xmlclob clob;
5146: xslclob clob;
5166: proc := dbms_xslprocessor.newProcessor;
5167:
5168: --apply stylesheet to DOM document
5169: outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
5170: outnode := dbms_xmldom.makenode(outdomdocf);
5171:
5172: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5173: dbms_xmldom.writetoclob(outnode,outclob);
5174:
5169: outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
5170: outnode := dbms_xmldom.makenode(outdomdocf);
5171:
5172: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5173: dbms_xmldom.writetoclob(outnode,outclob);
5174:
5175: RETURN XmlType(outclob);
5176:
5177: END Transform_XML;
5222:
5223: -- Code changes to optimize transform_xml API.
5224: xsldoc VARCHAR2(2000);
5225: myParser dbms_xmlparser.Parser;
5226: indomdoc dbms_xmldom.domdocument;
5227: xsltdomdoc dbms_xmldom.domdocument;
5228: xsl dbms_xslprocessor.stylesheet;
5229: outdomdocf dbms_xmldom.domdocumentfragment;
5230: outnode dbms_xmldom.domnode;
5223: -- Code changes to optimize transform_xml API.
5224: xsldoc VARCHAR2(2000);
5225: myParser dbms_xmlparser.Parser;
5226: indomdoc dbms_xmldom.domdocument;
5227: xsltdomdoc dbms_xmldom.domdocument;
5228: xsl dbms_xslprocessor.stylesheet;
5229: outdomdocf dbms_xmldom.domdocumentfragment;
5230: outnode dbms_xmldom.domnode;
5231: proc dbms_xslprocessor.processor;
5225: myParser dbms_xmlparser.Parser;
5226: indomdoc dbms_xmldom.domdocument;
5227: xsltdomdoc dbms_xmldom.domdocument;
5228: xsl dbms_xslprocessor.stylesheet;
5229: outdomdocf dbms_xmldom.domdocumentfragment;
5230: outnode dbms_xmldom.domnode;
5231: proc dbms_xslprocessor.processor;
5232: xslclob clob;
5233: outclob clob;
5226: indomdoc dbms_xmldom.domdocument;
5227: xsltdomdoc dbms_xmldom.domdocument;
5228: xsl dbms_xslprocessor.stylesheet;
5229: outdomdocf dbms_xmldom.domdocumentfragment;
5230: outnode dbms_xmldom.domnode;
5231: proc dbms_xslprocessor.processor;
5232: xslclob clob;
5233: outclob clob;
5234: --YJAIN
5571: dbms_xmlparser.parseclob(myParser, l_xml);
5572: indomdoc := dbms_xmlparser.getDocument(myParser);
5573: --apply stylesheet to DOM document
5574: outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
5575: outnode := dbms_xmldom.makenode(outdomdocf);
5576: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5577: dbms_xmldom.writetoclob(outnode,outclob);
5578: l_output_xml := XmlType(outclob);
5579: --l_output_xml := Transform_XML(l_xml, p_web_service_name);
5573: --apply stylesheet to DOM document
5574: outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
5575: outnode := dbms_xmldom.makenode(outdomdocf);
5576: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5577: dbms_xmldom.writetoclob(outnode,outclob);
5578: l_output_xml := XmlType(outclob);
5579: --l_output_xml := Transform_XML(l_xml, p_web_service_name);
5580: -- YJAIN
5581: ELSE
5703: dbms_xmlparser.parseclob(myParser, l_xml);
5704: indomdoc := dbms_xmlparser.getDocument(myParser);
5705: --apply stylesheet to DOM document
5706: outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
5707: outnode := dbms_xmldom.makenode(outdomdocf);
5708: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5709: dbms_xmldom.writetoclob(outnode,outclob);
5710: l_output_xml := XmlType(outclob);
5711: --l_output_xml := Transform_XML(l_xml, p_web_service_name);
5705: --apply stylesheet to DOM document
5706: outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
5707: outnode := dbms_xmldom.makenode(outdomdocf);
5708: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5709: dbms_xmldom.writetoclob(outnode,outclob);
5710: l_output_xml := XmlType(outclob);
5711: --l_output_xml := Transform_XML(l_xml, p_web_service_name);
5712: -- YJAIN
5713: