350: i_xslt_dir varchar2(200);
351: i_fullpath varchar2(200);
352: i_string varchar2(2000);
353: l_xslt_payload clob;
354: XSL_parser xmlparser.parser;
355: XML_parser xmlparser.parser;
356: l_xsl_doc xmldom.DOMDocument;
357: l_xml_doc xmldom.DOMDocument;
358: l_processed_xsl CLOB;
351: i_fullpath varchar2(200);
352: i_string varchar2(2000);
353: l_xslt_payload clob;
354: XSL_parser xmlparser.parser;
355: XML_parser xmlparser.parser;
356: l_xsl_doc xmldom.DOMDocument;
357: l_xml_doc xmldom.DOMDocument;
358: l_processed_xsl CLOB;
359: l_text varchar2(32767);
363: -- -- -- -- -- 3056514 fix -- --
364:
365: begin
366: /* convert i_xml_file from CLOB to DOMNode and set in ecx_utils.g_xmldoc */
367: xml_parser := xmlparser.newParser;
368: xmlparser.parseCLOB(xml_parser, P_XML);
369: l_xml_doc := xmlparser.getDocument(xml_parser);
370: ecx_utils.g_xmldoc:=xmlDOM.makeNode(l_xml_doc);
371: xmlParser.freeParser(xml_parser);
364:
365: begin
366: /* convert i_xml_file from CLOB to DOMNode and set in ecx_utils.g_xmldoc */
367: xml_parser := xmlparser.newParser;
368: xmlparser.parseCLOB(xml_parser, P_XML);
369: l_xml_doc := xmlparser.getDocument(xml_parser);
370: ecx_utils.g_xmldoc:=xmlDOM.makeNode(l_xml_doc);
371: xmlParser.freeParser(xml_parser);
372:
365: begin
366: /* convert i_xml_file from CLOB to DOMNode and set in ecx_utils.g_xmldoc */
367: xml_parser := xmlparser.newParser;
368: xmlparser.parseCLOB(xml_parser, P_XML);
369: l_xml_doc := xmlparser.getDocument(xml_parser);
370: ecx_utils.g_xmldoc:=xmlDOM.makeNode(l_xml_doc);
371: xmlParser.freeParser(xml_parser);
372:
373: /* convert l_xslt_paylod from clob to DOMDocument */
367: xml_parser := xmlparser.newParser;
368: xmlparser.parseCLOB(xml_parser, P_XML);
369: l_xml_doc := xmlparser.getDocument(xml_parser);
370: ecx_utils.g_xmldoc:=xmlDOM.makeNode(l_xml_doc);
371: xmlParser.freeParser(xml_parser);
372:
373: /* convert l_xslt_paylod from clob to DOMDocument */
374: xsl_parser := xmlparser.newParser;
375: xmlparser.parseCLOB(xsl_parser, P_XSL);
370: ecx_utils.g_xmldoc:=xmlDOM.makeNode(l_xml_doc);
371: xmlParser.freeParser(xml_parser);
372:
373: /* convert l_xslt_paylod from clob to DOMDocument */
374: xsl_parser := xmlparser.newParser;
375: xmlparser.parseCLOB(xsl_parser, P_XSL);
376: l_xsl_doc := xmlparser.getDocument(xsl_parser);
377:
378: /* get the stylesheet */
371: xmlParser.freeParser(xml_parser);
372:
373: /* convert l_xslt_paylod from clob to DOMDocument */
374: xsl_parser := xmlparser.newParser;
375: xmlparser.parseCLOB(xsl_parser, P_XSL);
376: l_xsl_doc := xmlparser.getDocument(xsl_parser);
377:
378: /* get the stylesheet */
379: i_stylesheet := xslprocessor.newStyleSheet(l_xsl_doc, null);
372:
373: /* convert l_xslt_paylod from clob to DOMDocument */
374: xsl_parser := xmlparser.newParser;
375: xmlparser.parseCLOB(xsl_parser, P_XSL);
376: l_xsl_doc := xmlparser.getDocument(xsl_parser);
377:
378: /* get the stylesheet */
379: i_stylesheet := xslprocessor.newStyleSheet(l_xsl_doc, null);
380: i_processor := xslprocessor.newProcessor;
399:
400: /*free all the used variables*/
401: if (xsl_parser.id <> -1)
402: then
403: xmlParser.freeParser(xsl_parser);
404: end if;
405: if (not xmldom.isNull(l_xsl_doc))
406: then
407: xmldom.freeDocument(l_xsl_doc);
410: /* Put All DOM Parser Exceptions Here. */
411: WHEN OTHERS THEN
412: if (xsl_parser.id <> -1)
413: then
414: xmlParser.freeParser(xsl_parser);
415: end if;
416: if (not xmldom.isNull(l_xsl_doc))
417: then
418: xmldom.freeDocument(l_xsl_doc);