This discussion is archived
4 Replies Latest reply: Feb 11, 2013 11:20 AM by Martin1 RSS

No rows in user_nested_tables after registerSchema

Martin1 Newbie
Currently Being Moderated
Hi,

i have registered a schema and then i get no rows from table user_nested_tables. Does anybody have an idea?
Here is the code:
DECLARE
--  vSchemaUrl   VARCHAR2(256) := 'http://llv15.gv.local:8082//home/FP/Source/xsd/ePassAntrag.xsd';
  vSchemaUrl   VARCHAR2(256) := '/home/FP/Source/xsd/ePassAntrag.xsd';
BEGIN
  dbms_xmlSchema.deleteSchema(vSchemaUrl, 4);
  COMMIT;
END;

DECLARE
  vRes         BOOLEAN;
  vSchemaPath  VARCHAR2(256) := '/home/FP/Source/xsd/ePassAntrag.xsd';
  vXmlSchema   XMLTYPE := xmlType(
'<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://www.llv.li" targetNamespace="http://www.llv.li" xmlns:xdb="http://xmlns.oracle.com/xdb" xdb:storeVarrayAsTable="true" elementFormDefault="qualified" attributeFormDefault="unqualified">
  <xs:element name="PassAntrag" type="tns:PassAntragTyp" xdb:defaultTable="FP_EPASS_PASS_ANTRAEGE"/>
  <xs:complexType name="PassAntragTyp" xdb:SQLType="FP_EPASS_PASS_ANTRAEGE_T" xdb:maintainDOM="false">
      <xs:sequence>
      <xs:element name="Antrag" type="tns:AntragTyp" xdb:SQLName="ANTRAG_TYP"/>
      <xs:element name="Person" type="tns:PersonTyp" xdb:SQLName="PERSON_TYP"/>
    </xs:sequence>
  </xs:complexType>
  <xs:complexType name="AntragTyp" xdb:SQLType="FP_EPASS_ANTRAEGE_T" xdb:maintainDOM="false">
    <xs:sequence>
      <xs:element name="UUID" default="0" nillable="false" xdb:SQLName="UUID" xdb:SQLType="NUMBER">
        <xs:annotation>
          <xs:documentation>UUID 38-stellig</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:decimal">
            <xs:minInclusive value="0"/>
            <xs:maxInclusive value="99999999999999999999999999999999999999"/>
            <xs:totalDigits value="38" fixed="true"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="DocTyp" default="PASS" nillable="false" xdb:SQLName="DOC_TYP">
        <xs:annotation>
          <xs:documentation>Typ des Dokuments</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="2" fixed="false"/>
            <xs:maxLength value="4" fixed="false"/>
            <xs:enumeration value="ID"/>
            <xs:enumeration value="KOMB"/>
            <xs:enumeration value="PASS"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Antragsgrund" default="ABL" nillable="false" xdb:SQLName="ANTRAGSGRUND">
        <xs:annotation>
          <xs:documentation>Grund des Antrags: Erstantrag(EAN), Ersatzantrag für abgelaufene und beschädigte Pässe(ABL), Verlustantrag(VER), Namensänderung(NAM)</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="3" fixed="false"/>
            <xs:maxLength value="3" fixed="false"/>
            <xs:enumeration value="EAN"/>
            <xs:enumeration value="ABL"/>
            <xs:enumeration value="VER"/>
            <xs:enumeration value="NAM"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="AntragDatum" nillable="false" xdb:SQLName="ANTRAG_DATUM">
        <xs:annotation>
          <xs:documentation>Datum des Antrags im Format DD.MM.YYYY</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="10"/>
            <xs:maxLength value="10"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="AntragOrt" default="*" nillable="false" xdb:SQLName="ANTRAG_ORT">
        <xs:annotation>
          <xs:documentation>Ort des Antrags</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1"/>
            <xs:maxLength value="60"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <xs:complexType name="PersonTyp" xdb:SQLType="FP_EPASS_PERSONEN_T" xdb:maintainDOM="false">
    <xs:sequence>
      <xs:element name="Name" nillable="false" xdb:SQLName="NANE">
        <xs:annotation>
          <xs:documentation>Name der Person</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1"/>
            <xs:maxLength value="512"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Vorname" nillable="false" xdb:SQLName="VORNAME">
        <xs:annotation>
          <xs:documentation>Vorname der Person</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1"/>
            <xs:maxLength value="512"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Geburtsdatum" default="31.12.4712" nillable="false" xdb:SQLName="GEBURTSDATUM">
        <xs:annotation>
          <xs:documentation>Geburtsdatum der Person im Format DD.MM.YYYY</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="10"/>
            <xs:maxLength value="10"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Geschlecht" default="M" nillable="false" xdb:SQLName="GESCHLECHT">
        <xs:annotation>
          <xs:documentation>Geschlecht der Person M | W</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1"/>
            <xs:maxLength value="1"/>
            <xs:enumeration value="M"/>
            <xs:enumeration value="W"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Passtitel" nillable="false" xdb:SQLName="PASSTITEL">
        <xs:annotation>
          <xs:documentation>Passtitel der Person </xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0"/>
            <xs:maxLength value="50"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Groesse" default="*" nillable="false" xdb:SQLName="GROESSE">
        <xs:annotation>
          <xs:documentation>Grösse der Person in cm, * bei Kindern</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1" fixed="false"/>
            <xs:maxLength value="3" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Strasse" default="*" nillable="false" xdb:SQLName="STRASSE">
        <xs:annotation>
          <xs:documentation>Amtliche Adresse der Person : Strasse</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1" fixed="false"/>
            <xs:maxLength value="60" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Hausnummer" default="*" nillable="false" xdb:SQLName="HAUSNUMMER">
        <xs:annotation>
          <xs:documentation>Amtliche Adresse der Person : Hausnummer</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1" fixed="false"/>
            <xs:maxLength value="10" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="PLZ" default="*" nillable="false" xdb:SQLName="PLZ">
        <xs:annotation>
          <xs:documentation>Amtliche Adresse der Person : PLZ</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1" fixed="false"/>
            <xs:maxLength value="12" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Ort" default="*" nillable="false" xdb:SQLName="ORT">
        <xs:annotation>
          <xs:documentation>Amtliche Adresse der Person : Ort</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="1" fixed="false"/>
            <xs:maxLength value="60" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="LandIso316613" default="LIE" nillable="false" xdb:SQLName="LAND_ISO_3166_13">
        <xs:annotation>
          <xs:documentation>Amtliche Adresse der Person : Kurzzeichen ISO 3166 1 3 des Landes</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="3" fixed="false"/>
            <xs:maxLength value="3" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Telefon" default="" nillable="false" xdb:SQLName="TELEFON">
        <xs:annotation>
          <xs:documentation>TelefonNr der Person für Erreichbarkeit zu Bürozeiten</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0" fixed="false"/>
            <xs:maxLength value="30" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Email" default="" nillable="false" xdb:SQLName="EMAIL">
        <xs:annotation>
          <xs:documentation>Email Adresse der Person für Erreichbarkeit</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0" fixed="false"/>
            <xs:maxLength value="255" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Versand" default="EDA" nillable="false" xdb:SQLName="VERSAND">
        <xs:annotation>
          <xs:documentation>Art des Pass-Versands</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="3" fixed="false"/>
            <xs:maxLength value="3" fixed="false"/>
            <xs:enumeration value="EDA"/>
            <xs:enumeration value="WHG"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="Lieferadresse" default="" nillable="false" xdb:SQLName="LIEFERADRESSE">
        <xs:annotation>
          <xs:documentation>Lieferadresse des Pass-Versands</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0" fixed="false"/>
            <xs:maxLength value="512" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="BesKennz" default="" nillable="true" xdb:SQLName="BES_KENNZ">
        <xs:annotation>
          <xs:documentation>Besondere Kennzeichen der Person</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0" fixed="false"/>
            <xs:maxLength value="200" fixed="false"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="NameVornameVater" default="" nillable="false" xdb:SQLName="NAME_VORNAME_VATER">
        <xs:annotation>
          <xs:documentation>Name und Vorname des Vaters</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0"/>
            <xs:maxLength value="512"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="LedNameVornameMutter" default="" nillable="false" xdb:SQLName="LED_NAME_VORNAME_MUTTER">
        <xs:annotation>
          <xs:documentation>Lediger Name und Vorname der Mutter</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0"/>
            <xs:maxLength value="512"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="NameVornameEhepartner" default="" nillable="false" xdb:SQLName="NAME_VORNAME_EHEPARTNER">
        <xs:annotation>
          <xs:documentation>Name und Vorname des Ehepartners</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0"/>
            <xs:maxLength value="512"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="NameVornameVertreter" default="" nillable="true" xdb:SQLName="NAME_VORNAME_VERTRETER">
        <xs:annotation>
          <xs:documentation>Name und Vorname des gesetzlichen Vertreters</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0"/>
            <xs:maxLength value="512"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FotoID" nillable="true" xdb:SQLName="FOTO_ID" xdb:SQLType="CLOB">
        <xs:annotation>
          <xs:documentation>Foto der Person für die ID (ID: nicht optional; muss mit SafeID abgesprochen werden)</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:base64Binary"/>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FotoPass" nillable="true" xdb:SQLName="FOTO_PASS" xdb:SQLType="CLOB">
        <xs:annotation>
          <xs:documentation>Foto der Person für den Pass (PASS: nicht optional; muss mit SafeID abgesprochen werden)</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:base64Binary"/>
        </xs:simpleType>
      </xs:element>
      <xs:element name="SignID" nillable="true" xdb:SQLName="SIGN_ID" xdb:SQLType="CLOB">
        <xs:annotation>
          <xs:documentation>Unterschrift der Person für die ID (ID: nicht optional; muss mit SafeID abgesprochen werden)</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:base64Binary"/>
        </xs:simpleType>
      </xs:element>
      <xs:element name="SignPass" nillable="true" xdb:SQLName="SIGN_PASS" xdb:SQLType="CLOB">
        <xs:annotation>
          <xs:documentation>Unterschrift der Person für den Pass (PASS: nicht optional; muss mit SafeID abgesprochen werden)</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:base64Binary"/>
        </xs:simpleType>
      </xs:element>
      <xs:element name="SignVertreter" nillable="true" xdb:SQLName="SIGN_VERTTRETER" xdb:SQLType="CLOB">
        <xs:annotation>
          <xs:documentation>Unterschrift des gestzlichen Vertreters</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:base64Binary"/>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpDG3" nillable="true" xdb:SQLName="FP_DG3" xdb:SQLType="CLOB">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [DG3] (KOMB und PASS: nicht optional)</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:base64Binary"/>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpFinger1" nillable="true" xdb:SQLName="FP_FINGER1" xdb:SQLType="NUMBER">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [Finger1] (KOMB und PASS: nicht optional) 1=r.Daumen;2=r.Zeige;3=r.Mittel;4=r.Ring;(5=r.Klein); 6=l.Daumen;7=l.Zeige;8=l.Mittel;9=l.Ring;10=l.Klein;20=kein Finger</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:long">
            <xs:minInclusive value="1"/>
            <xs:maxInclusive value="20"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpQualitaet1" nillable="true" xdb:SQLName="FP_QUALITAET1" xdb:SQLType="NUMBER">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [Qualität1] (KOMB und PASS: nicht optional)</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:long">
            <xs:minInclusive value="0"/>
            <xs:maxInclusive value="100"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpCaptureDevice1" nillable="true" xdb:SQLName="FP_CAPTURE_DEVICE1" xdb:SQLType="VARCHAR2">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [CaptureDevice1]</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0"/>
            <xs:maxLength value="200"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpWSQ1" nillable="true" xdb:SQLName="FP_WSQ1" xdb:SQLType="CLOB">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [WSQ1]</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:base64Binary"/>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpFinger2" nillable="true" xdb:SQLName="FP_FINGER2" xdb:SQLType="NUMBER">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [Finger2] (KOMB und PASS: nicht optional) 1=r.Daumen;2=r.Zeige;3=r.Mittel;4=r.Ring;(5=r.Klein); 6=l.Daumen;7=l.Zeige;8=l.Mittel;9=l.Ring;10=l.Klein;20=kein Finger</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:long">
            <xs:minInclusive value="1"/>
            <xs:maxInclusive value="20"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpQualitaet2" nillable="true" xdb:SQLName="FP_QUALITAET2" xdb:SQLType="NUMBER">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [Qualität2]</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:long">
            <xs:minInclusive value="0"/>
            <xs:maxInclusive value="100"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpCaptureDevice2" nillable="true" xdb:SQLName="FP_CAPTURE_DEVICE2" xdb:SQLType="VARCHAR2">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [CaptureDevice2]</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:minLength value="0"/>
            <xs:maxLength value="200"/>
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <xs:element name="FpWSQ2" nillable="true" xdb:SQLName="FP_WSQ2" xdb:SQLType="CLOB">
        <xs:annotation>
          <xs:documentation>Fingerprint der Person [WSQ2]</xs:documentation>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:base64Binary"/>
        </xs:simpleType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:schema>
');
BEGIN
  IF dbms_xdb.existsResource(vSchemaPath) THEN
    dbms_xdb.deleteResource(vSchemaPath);
  END IF;
  vRes := dbms_xdb.createResource(vSchemaPath, vXmlSchema);
  COMMIT;
END;

DECLARE
  vSchemaPath  VARCHAR2(256) := '/home/FP/Source/xsd/ePassAntrag.xsd';
  vSchemaUrl   VARCHAR2(256) := 'http://llv15.gv.local:8082//home/FP/Source/xsd/ePassAntrag.xsd';
BEGIN
  dbms_xmlschema.registerSchema(vSchemaPath, xdbURIType(vSchemaPath).getClob(),
    TRUE, TRUE, FALSE, FALSE);
  COMMIT;
END;

select table_name
from user_nested_tables;
Many thanks in advance.

Regards,
Martin
  • 1. Re: No rows in user_nested_tables after registerSchema
    mdrake Expert
    Currently Being Moderated
    GENTABLES is false ?
    PROCEDURE REGISTERSCHEMA
     Argument Name                  Type                    In/Out Default?
     ------------------------------ ----------------------- ------ --------
     SCHEMAURL                      VARCHAR2                IN
     SCHEMADOC                      CLOB                    IN
     LOCAL                          BOOLEAN                 IN     DEFAULT
     GENTYPES                       BOOLEAN                 IN     DEFAULT
     GENBEAN                        BOOLEAN                 IN     DEFAULT
     GENTABLES                      BOOLEAN                 IN     DEFAULT
     FORCE                          BOOLEAN                 IN     DEFAULT
     OWNER                          VARCHAR2                IN     DEFAULT
     ENABLEHIERARCHY                BINARY_INTEGER          IN     DEFAULT
     OPTIONS                        BINARY_INTEGER          IN     DEFAULT
     SCHEMAOID                      RAW                     IN     DEFAULT
     IMPORT_OPTIONS                 BINARY_INTEGER          IN     DEFAULT
    Nested tables are related to the top level table. They will only be generated when the top level table is generated. THe top level table is only generated when GENTABLES is true, or when a table is created using a CREATE TABLE with an XMLSCHMA clause
  • 2. Re: No rows in user_nested_tables after registerSchema
    Martin1 Newbie
    Currently Being Moderated
    Hi mdrake,

    many thanks for your reply.

    Now i register the schema by the following statement, but the query on the table user_nested_tables does still bring no rows.
    DECLARE
      vSchemaPath  VARCHAR2(256) := '/home/FP/Source/xsd/ePassAntrag.xsd';
      vSchemaUrl   VARCHAR2(256) := 'http://llv15.gv.local:8082//home/FP/Source/xsd/ePassAntrag.xsd';
    BEGIN
      dbms_xmlschema.registerSchema(schemaurl => vSchemaPath,
        schemadoc => xdbURIType(vSchemaPath).getClob(), local => TRUE,
          gentypes => TRUE, gentables => TRUE, force => FALSE);
      COMMIT;
    END;
    Only the following database ojects are created:
    - Table FP_EPASS_PASS_ANTRAEGE
    - Object type FP_EPASS_ANTRAEGE_T
    - Object type FP_EPASS_PASS_ANTRAEGE_T
    - Object type FP_EPASS_PERSONEN_T

    Many thanks in advance.

    Best Regards,
    Martin
  • 3. Re: No rows in user_nested_tables after registerSchema
    odie_63 Guru
    Currently Being Moderated
    Hi Martin,

    The schema doesn't contain any collection of repeating elements, therefore no nested tables are necessary.
  • 4. Re: No rows in user_nested_tables after registerSchema
    Martin1 Newbie
    Currently Being Moderated
    Hi,

    thanks a lot for your reply. I will go now further in inserting the xml file.

    Best regards,
    Martin

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points