hi,
I am generating xml output in apps(xml publisher) using pl/sql.
I am getting the output with no error for smaller results, but i am getting the ERROR "Cannot view XML input using XSL style sheet" for larger results.
Following is my xml output with error:
- <ROW>
<PO_NUMBER>18828610</PO_NUMBER>
<VENDOR_NAME>SIGMA ALDRICH</VENDOR_NAME>
<VENDOR_NUM>000352</VENDOR_NUM>
<BUYER_ID>EDI_DELPHI</BUYER_ID>
<PO_STATUS>APPROVED</PO_STATUS>
<REQ_RECEIVED_DT>12-JAN-07</REQ_RECEIVED_DT>
<PO_APPROVAL_DT>12-JAN-07</PO_APPROVAL_DT>
<PO_PTA>1092687-101-DAABD</PO_PTA>
<CAT_SEGMENT_1>CWA</CAT_SEGMENT_1>
<PO_DEPT_NAME>Cancer Stem Cells One Times</PO_DEPT_NAME>
<REQ_REQUESTOR_NAME>Urbani, Lenore</REQ_REQUESTOR_NAME>
<REQ_REQUESTOR_PHONE>(650) 736-4301</REQ_REQUESTOR_PHONE>
<REQ_ORIGINATOR_NAME>Urbani, Lenore</REQ_ORIGINATOR_NAME>
<REQ_ORIGINATOR_PHONE>(650) 736-4301</REQ_ORIGINATOR_PHONE>
<REQ_ORIGINATOR_EMAIL>lurbani@stanford.edu</REQ_ORIGINATOR_EMAIL>
<PO_TOTAL>117.42</PO_TOTAL>
<PO_PTD_AMT>270.82</PO_PTD_AMT>
</ROW>
- <ROW>
<PO_NUMBER>18828590</PO_NUMBER>
<VENDOR_NAME>INVITROGEN</VENDOR_NAME>
<VENDOR_NUM>011376</VENDOR_NUM>
<BUYER_ID>RPO_DELPHI</BUYER_ID>
<PO_STATUS>APPROVED</PO_STATUS>
<REQ_RECEIVED_DT>12-JAN-07</<The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
End tag 'VENDOR_NAM' does not match the start tag 'VENDOR_NAME'. Error processing resource 'https://of1dev.stanford.edu:801...
<VENDOR_NAME>CORPORATE EXPRESS</VENDOR_NAM
----------------------------------^
/SPAN>REQ_RECEIVED_DT>
<PO_APPROVAL_DT>12-JAN-07</PO_APPROVAL_DT>
<PO_PTA>1018713-110-PAGOD</PO_PTA>
<CAT_SEGMENT_1>RPO</CAT_SEGMENT_1>
<PO_DEPT_NAME>16766</PO_DEPT_NAME>
please help me ..........
Thanks
Spriha