Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

nXSD issue with array

2795740Apr 1 2016 — edited Feb 26 2020

Hi,

I am reading a delimited flat file, Please find the contents below.

I created the NXSD for it in Jdev version 11.1.1.7, Please help me identify the issue in the nxsd.

N1^BY^ER^92^316000^2742^3013

N1^SE^STRM^93

N1^SE^5004200283^92^ER

nxsd created in Jdev

------------------------------

<?xml version="1.0" encoding="UTF-8" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"

            xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"

            xmlns:tns="http://TargetNamespace.com/InboundService"

            targetNamespace="http://TargetNamespace.com/InboundService"

            elementFormDefault="qualified" attributeFormDefault="unqualified"

            nxsd:version="NXSD" nxsd:stream="chars" nxsd:encoding="US-ASCII">

  <xsd:element name="Root-Element">

    <xsd:complexType>

      <xsd:sequence>

        <xsd:element name="N1TYPE" type="tns:complex" maxOccurs="unbounded"/>

      </xsd:sequence>

    </xsd:complexType>

  </xsd:element>

  <xsd:complexType name="complex">

    <xsd:sequence>

      <xsd:element name="test" type="xsd:string" maxOccurs="unbounded"

                   nxsd:style="array" nxsd:cellSeparatedBy="^"

                   nxsd:arrayTerminatedBy="${eol}"/>

    </xsd:sequence>

  </xsd:complexType>

</xsd:schema>

<!--NXSDWIZ:C\Samples\Test.txt:-->

<!--USE-HEADER:false:-->

Output:

<?xml version = '1.0' encoding = 'UTF-8'?>

<Root-Element xmlns="http://TargetNamespace.com/InboundService">

   <N1TYPE>

      <test>N1</test>

      <test>BY</test>

      <test>ER</test>

      <test>92</test>

      <test>316000</test>

      <test>2742</test>

      <test>3013</test>

   </N1TYPE>

   <N1TYPE>

      <test>N1</test>

   </N1TYPE>

   <N1TYPE>

      <test>SE</test>

   </N1TYPE>

   <N1TYPE>

      <test>STRM</test>

   </N1TYPE>

   <N1TYPE>

      <test>93</test>

   </N1TYPE>

   <N1TYPE>

      <test>N1</test>

   </N1TYPE>

   <N1TYPE>

      <test>SE</test>

   </N1TYPE>

   <N1TYPE>

      <test>5004200283</test>

   </N1TYPE>

   <N1TYPE>

      <test>92</test>

   </N1TYPE>

   <N1TYPE>

      <test>ER</test>

   </N1TYPE>

</Root-Element>

Expected Output:

<?xml version = '1.0' encoding = 'UTF-8'?>

<Root-Element xmlns="http://TargetNamespace.com/InboundService">

   <N1TYPE>

      <test>N1</test>

      <test>BY</test>

      <test>ER</test>

      <test>92</test>

      <test>316000</test>

      <test>2742</test>

      <test>3013</test>

   </N1TYPE>

   <N1TYPE>

      <test>N1</test>

      <test>SE</test>

      <test>STRM</test>

      <test>93</test> 

   <N1TYPE>

     <test>N1</test>

      <test>SE</test>

      <test>5004200283</test>

      <test>92</test>

      <test>ER</test>

   </N1TYPE>

</Root-Element>

This post has been answered by Bernardo Cabaços on Apr 1 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2016
Added on Apr 1 2016
3 comments
1,299 views