Skip to Main Content
Forums

SQL & PL/SQL

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!

Large xsd file cannot be stored in CLOB variable

sgalaxyOct 31 2019 — edited Nov 3 2019

Hi,

The below .xsd file cannot be set to a clob variable.

The error message PLS-00172: string literal too long is displayed.

In reality, i' m trying to validate an xml file using the .xsd file, following the https://oracle-base.com/articles/misc/validate-xml-against-xml-schema-xsd

Is there any way to solve the problem?

Note: I use Oracle db11g v2

DECLARE
  l_schema clob;
  
BEGIN
l_schema := '<?xml version="1.0" encoding="utf-8" ?>
<!--Created with Liquid XML Studio Developer Edition (Trial) 8.1.7.2743 (http://www.liquid-technologies.com)-->
<xs:schema xmlns="http://www.yeka.gr/E4" xml:lang="gr" attributeFormDefault="unqualified" targetNamespace="http://www.yeka.gr/E4" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:complexType name="ErgazomenosE4Type">
        <xs:sequence>
            <xs:element name="f_aa" nillable="false">
                <xs:annotation>
                    <xs:documentation>Α/Α</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,5}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_afm" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΑΡΙΘΜΟΣ ΦΟΡΟΛΟΓΙΚΟΥ ΜΗΤΡΩΟΥ (Α.Φ.Μ.)</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]){9}" />
                        <xs:length value="9" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_amka" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΑΡΙΘΜΟΣ ΜΗΤΡΩΟΥ ΚΟΙΝΩΝΙΚΗΣ ΑΣΦΑΛΙΣΗΣ (Α.Μ.Κ.Α.)</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{11}" />
                        <xs:length value="11" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_amika">
                <xs:annotation>
                    <xs:documentation>ΑΡΙΘΜΟΣ ΜΗΤΡΩΟΥ (Ασφαλισμένου) Ι.Κ.Α.</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{0,20}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_eponymo" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΕΠΩΝΥΜΟ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_onoma" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΟΝΟΜΑ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="30" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_onoma_patera" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΟΝΟΜΑ ΠΑΤΕΡΑ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="30" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_onoma_miteras" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΟΝΟΜΑ ΜΗΤΕΡΑΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="30" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_sex" nillable="false">
                <xs:annotation><xs:documentation>ΦΥΛΟ - (0) ΑΝΤΡΑΣ - (1) ΓΥΝΑΙΚΑ</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:enumeration value="0"/>
                        <xs:enumeration value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_birthdate" nillable="false">
                <xs:annotation><xs:documentation>ΗΜΕΡΟΜΗΝΙΑ ΓΕΝΝΗΣΗΣ</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="(([0]?)([1-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([1])([0-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-9])([/])([0]?1|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-8])([/])([0]?2)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([9])([/])([0]?2)([/])([1-2])([0-9])(00|04|08|12|16|20|24|28|32|36|40|44|48|52|56|60|64|68|72|76|80|84|88|92|96))|(([3])([0-1])([/])(01|03|05|07|08|10|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([3])([0])([/])(04|06|09|11)([/])([1-2])([0-9])([0-9])([0-9]))"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_marital_status" nillable="false">
                <xs:annotation><xs:documentation>ΟΙΚΟΓ. ΚΑΤΑΣΤΑΣΗ - (0) ΑΓΑΜΟΣ - (1) ΕΓΓΑΜΟΣ - (2) ΔΙΑΖΕΥΓΜΕΝΟΣ - (3) ΧΗΡΟΣ</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:enumeration value="0"/>
                        <xs:enumeration value="1"/>
                        <xs:enumeration value="2"/>
                        <xs:enumeration value="3"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_arithmos_teknon" nillable="false">
                <xs:annotation><xs:documentation>ΑΡΙΘΜΟΣ ΤΕΚΝΩΝ</xs:documentation></xs:annotation>
                <xs:simpleType>
                   <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,3}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_eidikothta">
                <xs:annotation>
                    <xs:documentation>ΕΙΔΙΚΟΤΗΤΑ (ΑΝΑΛΥΤΙΚΑ ΑΝ ΑΠΑΙΤΕΙΤΑΙ)</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
             <xs:element name="f_date_proslipsis" nillable="false">
                <xs:annotation><xs:documentation>ΗΜΕΡΟΜΗΝΙΑ ΠΡΟΣΛΗΨΗΣ</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="(([0]?)([1-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([1])([0-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-9])([/])([0]?1|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-8])([/])([0]?2)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([9])([/])([0]?2)([/])([1-2])([0-9])(00|04|08|12|16|20|24|28|32|36|40|44|48|52|56|60|64|68|72|76|80|84|88|92|96))|(([3])([0-1])([/])(01|03|05|07|08|10|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([3])([0])([/])(04|06|09|11)([/])([1-2])([0-9])([0-9])([0-9]))"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_proipiresia" nillable="false">
                <xs:annotation><xs:documentation>ΠΡΟΥΠΗΡΕΣΙΑ ΣΕ ΕΤΗ</xs:documentation></xs:annotation>
                <xs:simpleType>
                   <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,3}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_date_anaggelias" nillable="false">
                <xs:annotation><xs:documentation>ΣΤΟΙΧΕΙΑ  Κ.Π. ΟΑΕΔ (ΗΜΕΡΟΜΗΝΙΑ ΑΝΑΓΓΕΛΙΑΣ  ΠΡΟΣΛΗΨΗΣ)</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="(([0]?)([1-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([1])([0-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-9])([/])([0]?1|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-8])([/])([0]?2)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([9])([/])([0]?2)([/])([1-2])([0-9])(00|04|08|12|16|20|24|28|32|36|40|44|48|52|56|60|64|68|72|76|80|84|88|92|96))|(([3])([0-1])([/])(01|03|05|07|08|10|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([3])([0])([/])(04|06|09|11)([/])([1-2])([0-9])([0-9])([0-9]))|([ ]*)"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_arithmos_vivliou_anilikou">
                <xs:annotation>
                    <xs:documentation>ΑΡΙΘΜΟΣ ΒΙΒΛΙΑΡΙΟΥ ΕΡΓΑΣΙΑΣ ΑΝΗΛΙΚΟΥ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="20" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_arithmos_adeias_ergasias">
                <xs:annotation>
                    <xs:documentation>ΑΡΙΘΜΟΣ ΑΔΕΙΑΣ ΕΡΓΑΣΙΑΣ ΑΛΛΟΔΑΠΟΥ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="20" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_wres_ergasias" >
                <xs:annotation>
                    <xs:documentation>ΩΡΕΣ ΕΝΑΡΞΗΣ ΚΑΙ ΛΗΞΗΣ ΗΜΕΡΕΣ ΕΡΓΑΣΙΑΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="200" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_wres_external" nillable="false">
                <xs:annotation><xs:documentation>ΩΡΕΣ ΕΝΑΡΞΗΣ ΚΑΙ ΛΗΞΗΣ ΗΜΕΡΕΣ ΕΡΓΑΣΙΑΣ ΜΕ ΕΠΙΣΥΝΑΠΤΟΜΕΝΟ ΑΡΧΕΙΟ - (0) ΟΧΙ - (1) ΝΑΙ</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:enumeration value="0"/>
                        <xs:enumeration value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_wres_dialeimatos" >
                <xs:annotation>
                    <xs:documentation>ΩΡΕΣ ΔΙΑΛΕΙΜΜΑΤΟΣ -ΔΙΑΚΟΠΗΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="200" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_apodoxes" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΣΥΝΟΛΟ ΜΕΙΚΤΩΝ ΑΠΟΔΟΧΩΝ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]{1,3}\.([0-9]{3}\.)*[0-9]{3}|[0-9]+)(,[0-9][0-9])|([ ]*)"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_parathrhseis" >
                <xs:annotation>
                    <xs:documentation>ΠΑΡΑΤΗΡΗΣΕΙΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="500" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_special_case" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΕΙΔΙΚΗ ΠΕΡΙΠΤΩΣΗ - (1) Πρακτική άσκηση σπουδαστών - (2) Ιδ. δικαίου - στενό δημόσιο - (3) Ιδ. δικαίου - ευρύτερο δημόσιο </xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:enumeration value=""/>
                        <xs:enumeration value="1"/>
                        <xs:enumeration value="2"/>
                        <xs:enumeration value="3"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_xaraktirismos" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΧΑΡΑΚΤΗΡΙΣΜΟΣ ΕΡΓΑΖΟΜΕΝΟΥ ΩΣ ΠΡΟΣ ΤΗΝ ΙΔΙΟΤΗΤΑ ΤΟΥ - (0) Εργάτης - (1) Υπάλληλος</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:enumeration value="0"/>
                        <xs:enumeration value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_week_hours" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΩΡΕΣ ΕΡΓΑΣΙΑΣ ΕΒΔΟΜΑΔΙΑΙΩΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]{3}|[0-9]+)(,[0-9])"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_change_date" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΗΜ/ΝΙΑ ΤΡΟΠ. ΑΠΟΔΟΧ/ΩΡΑΡ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="(([0]?)([1-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([1])([0-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-9])([/])([0]?1|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-8])([/])([0]?2)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([9])([/])([0]?2)([/])([1-2])([0-9])(00|04|08|12|16|20|24|28|32|36|40|44|48|52|56|60|64|68|72|76|80|84|88|92|96))|(([3])([0-1])([/])(01|03|05|07|08|10|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([3])([0])([/])(04|06|09|11)([/])([1-2])([0-9])([0-9])([0-9]))|([ ]*)"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_hour_apodoxes" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΩΡΟΜΙΣΘΙΟ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]{1,3}\.([0-9]{3}\.)*[0-9]{3}|[0-9]+)(,[0-9][0-9])|([ ]*)"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_step" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΕΙΔΙΚΟΤΗΤΑ ΚΩΔΙΚΟΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,6}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_sxeshapasxolisis" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΣΧΕΣΗ ΕΡΓΑΣΙΑΣ (ΤΥΠΟΣ ΑΠΑΣΧΟΛΗΣΗΣ) (0) ΑΟΡΙΣΤΟΥ ΧΡΟΝΟΥ (1) ΟΡΙΣΜΕΝΟΥ ΧΡΟΝΟΥ </xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:enumeration value="0"/>
                        <xs:enumeration value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_kathestosapasxolisis" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΚΑΘΕΣΤΩΣ ΑΠΑΣΧΟΛΗΣΗΣ (0) ΠΛΗΡΗΣ (1) ΜΕΡΙΚΗ (2) ΕΚ ΠΕΡΙΤΡΟΠΗΣ </xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:enumeration value="0"/>
                        <xs:enumeration value="1"/>
                        <xs:enumeration value="2"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
        </xs:sequence>
    </xs:complexType>
    <xs:complexType name="ErgazomenoiE4Type">
        <xs:sequence>
            <xs:element name="ErgazomenoiE4" type="ErgazomenosE4Type"  minOccurs="1"  maxOccurs="unbounded">
                <xs:annotation>
                    <xs:documentation>Εργαζόμενοι Πίνακα Προσωπικού Ε4</xs:documentation>
                </xs:annotation>
            </xs:element>
        </xs:sequence>
    </xs:complexType>
    <xs:complexType name="SKE4Type">
        <xs:sequence>
            <xs:element name="f_aa_pararthmatos" nillable="false">
                <xs:annotation>
                    <xs:documentation>Α/Α ΠΑΡΑΡΤΗΜΑΤΟΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,5}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_rel_protocol">
                <xs:annotation>
                    <xs:documentation>ΣΧΕΤΙΚΟ ΕΝΤΥΠΟ ΑΡΙΘ. ΠΡΩΤ.</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_rel_date">
                <xs:annotation><xs:documentation>ΣΧΕΤΙΚΟ ΕΝΤΥΠΟ ΗΜΕΡΟΜΗΝΙΑ</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="(([0]?)([1-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([1])([0-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-9])([/])([0]?1|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-8])([/])([0]?2)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([9])([/])([0]?2)([/])([1-2])([0-9])(00|04|08|12|16|20|24|28|32|36|40|44|48|52|56|60|64|68|72|76|80|84|88|92|96))|(([3])([0-1])([/])(01|03|05|07|08|10|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([3])([0])([/])(04|06|09|11)([/])([1-2])([0-9])([0-9])([0-9]))|([ ]*)"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_ypiresia_sepe" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΚΩΔΙΚΟΣ ΥΠΗΡΕΣΙΑΣ ΣΕΠΕ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{5}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_kad_pararthmatos" nillable="false">
                <xs:annotation>
                    <xs:documentation>Κ.Α.Δ. ΠΑΡΑΡΤΗΜΑΤΟΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{4}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_kallikratis_pararthmatos" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΔΗΜΟΤΙΚΗ / ΤΟΠΙΚΗ ΚΟΙΝΟΤΗΤΑ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{8}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_men" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΆΝΔΡΕΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,6}"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>    
            <xs:element name="f_women" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΓΥΝΑΙΚΕΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,6}"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>    
            <xs:element name="f_underage" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΑΝΗΛΙΚΟΙ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,6}"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>    
            <xs:element name="f_total" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΣΥΝΟΛΟ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{1,6}"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
           <xs:element name="f_comments" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΠΑΡΑΤΗΡΗΣΕΙΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="200" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <!-- ΣΤΟΙΧΕΙΑ ΕΡΓΟΔΟΤΗ – ΝΟΜΙΜΟΥ ΕΚΠΡΟΣΩΠΟΥ -->
            <xs:element name="f_afm_proswpoy" nillable="false">
                <xs:annotation>
                    <xs:documentation>Νόμιμος Εκπρόσωπος (Α.Φ.Μ.)</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]){9}" />
                        <xs:length value="9" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_kallikratis_proswpoy" nillable="false">
                <xs:annotation>
                    <xs:documentation>Νόμιμος Εκπρόσωπος ΔΗΜΟΤΙΚΗ / ΤΟΠΙΚΗ ΚΟΙΝΟΤΗΤΑ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{8}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <!-- ΤΕΛΟΣ ΣΤΟΙΧΕΙΑ ΕΡΓΟΔΟΤΗ – ΝΟΜΙΜΟΥ ΕΚΠΡΟΣΩΠΟΥ -->
            <!-- ΣΤΟΙΧΕΙΑ ΒΕΒΑΙΩΝ -->
            <xs:element name="f_eponymo_idiotitas" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΒΕΒΑΙΩΝ ΕΠΩΝΥΜΟ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_onoma_idiotitas" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΒΕΒΑΙΩΝ ΟΝΟΜΑ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_idiotita_idiotitas" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΒΕΒΑΙΩΝ ΙΔΙΟΤΗΤΑ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_dieythinsi_idiotitas" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΒΕΒΑΙΩΝ ΔΙΕΥΘΥΝΣΗ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_til_idiotitas">
                <xs:annotation>
                    <xs:documentation>ΒΕΒΑΙΩΝ ΤΗΛΕΦΩΝΟ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_afm_idiotitas" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΒΕΒΑΙΩΝ Α.Φ.Μ.</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]){9}" />
                        <xs:length value="9" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element> 
            <xs:element name="f_doy_idiotitas">
                <xs:annotation>
                    <xs:documentation>ΒΕΒΑΙΩΝ Δ.Ο.Υ.</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="[0-9]{4}" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <!-- ΤΕΛΟΣ ΣΤΟΙΧΕΙΑ ΒΕΒΑΙΩΝ -->
            <!-- ΣΤΟΙΧΕΙΑ ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ -->
            <xs:element name="f_eponymo_texnikos" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ ΕΠΩΝΥΜΟ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_onoma_texnikos" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ ΟΝΟΜΑ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_afm_texnikos" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ Α.Φ.Μ.</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]){9}" />
                        <xs:length value="9" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element> 
            <xs:element name="f_year_hours_texnikos" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ ΕΤΗΣΙΕΣ ΩΡΕΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]{1,3}\.([0-9]{3}\.)*[0-9]{3}|[0-9]+)(,[0-9])"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_protocol_texnikos" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ Α.Π.  ΗΜΕΡΟΜΗΝΙΑ ΚΑΤΑΘΕΣΗΣ ΔΙΚ/ΚΩΝ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_date_texnikos" nillable="false">
                <xs:annotation><xs:documentation>ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ Α.Π. ΗΜΕΡΟΜΗΝΙΑ ΚΑΤΑΘΕΣΗΣ ΔΙΚ/ΚΩΝ ΙΣΧΥΣ ΕΩΣ</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="(([0]?)([1-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([1])([0-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-9])([/])([0]?1|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-8])([/])([0]?2)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([9])([/])([0]?2)([/])([1-2])([0-9])(00|04|08|12|16|20|24|28|32|36|40|44|48|52|56|60|64|68|72|76|80|84|88|92|96))|(([3])([0-1])([/])(01|03|05|07|08|10|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([3])([0])([/])(04|06|09|11)([/])([1-2])([0-9])([0-9])([0-9]))"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_orario_texnikos" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ ΩΡΑΡΙΟ ΑΠΑΣΧΟΛΗΣΗΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                        <xs:minLength value="1"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <!-- ΤΕΛΟΣ ΣΤΟΙΧΕΙΑ ΤΕΧΝΙΚΟΣ ΑΣΦΑΛΕΙΑΣ -->
            <!-- ΣΤΟΙΧΕΙΑ ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ -->
            <xs:element name="f_eponymo_iatros" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ ΕΠΩΝΥΜΟ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_onoma_iatros" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ ΟΝΟΜΑ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_afm_iatros" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ Α.Φ.Μ.</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="([0-9]{9})|([ ]*)" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element> 
            <xs:element name="f_year_hours_iatros" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ ΕΤΗΣΙΕΣ ΩΡΕΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="(([0-9]{1,3}\.([0-9]{3}\.)*[0-9]{3}|[0-9]+)(,[0-9]))|([ ]*)"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_protocol_iatros" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ Α.Π.  ΗΜΕΡΟΜΗΝΙΑ ΚΑΤΑΘΕΣΗΣ ΔΙΚ/ΚΩΝ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_date_iatros" nillable="false">
                <xs:annotation><xs:documentation>ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ Α.Π. ΗΜΕΡΟΜΗΝΙΑ ΚΑΤΑΘΕΣΗΣ ΔΙΚ/ΚΩΝ ΙΣΧΥΣ ΕΩΣ</xs:documentation></xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:pattern value="((([0]?)([1-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([1])([0-9])([/])([0]?1|[0]?2|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-9])([/])([0]?1|[0]?3|[0]?4|[0]?5|[0]?6|[0]?7|[0]?8|[0]?9|10|11|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([0-8])([/])([0]?2)([/])([1-2])([0-9])([0-9])([0-9]))|(([2])([9])([/])([0]?2)([/])([1-2])([0-9])(00|04|08|12|16|20|24|28|32|36|40|44|48|52|56|60|64|68|72|76|80|84|88|92|96))|(([3])([0-1])([/])(01|03|05|07|08|10|12)([/])([1-2])([0-9])([0-9])([0-9]))|(([3])([0])([/])(04|06|09|11)([/])([1-2])([0-9])([0-9])([0-9])))|([ ]*)"/>
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <xs:element name="f_orario_iatros" nillable="false">
                <xs:annotation>
                    <xs:documentation>ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ ΩΡΑΡΙΟ ΑΠΑΣΧΟΛΗΣΗΣ</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            <!-- ΤΕΛΟΣ ΣΤΟΙΧΕΙΑ ΙΑΤΡΟΣ ΕΡΓΑΣΙΑΣ -->
            <xs:element name="f_file">
                <xs:annotation>
                <xs:documentation>Αρχείο Εντύπου Αρχείο(pdf)</xs:documentation>
                </xs:annotation>
                <xs:simpleType>
                    <xs:restriction base="xs:base64Binary">
                    </xs:restriction>
                </xs:simpleType>
            </xs:element>
            
            <!-- END Ε4 -->
            
            
            <xs:element name="Ergazomenoi" type="ErgazomenoiE4Type">
                <xs:annotation>
                    <xs:documentation>ΕΡΓΑΖΟΜΕΝΟΙ Ε4</xs:documentation>
                </xs:annotation>
            </xs:element>           
           
        </xs:sequence>
    </xs:complexType>
    <xs:complexType name="SKsE4Type">
        <xs:sequence>
            <xs:element name="SKE4" type="SKE4Type"  minOccurs="1"  maxOccurs="unbounded">
                <xs:annotation>
                    <xs:documentation>Πινακας Προσωπικού Ε4</xs:documentation>
                </xs:annotation>
            </xs:element>
        </xs:sequence>
    </xs:complexType>
    <xs:element name="SKsE4" type="SKsE4Type">
        <xs:annotation>
            <xs:documentation>Πίνακες Προσωπικού Ε4</xs:documentation>
        </xs:annotation>
    </xs:element>
</xs:schema>';
DBMS_XMLSCHEMA.registerSchema(schemaurl       =>'E4.xsd', 
                                 schemadoc       => l_schema,
                                 local           => TRUE,
                                 gentypes        => FALSE,
                                 gentables       => FALSE,
                                 enablehierarchy => DBMS_XMLSCHEMA.enable_hierarchy_none); 
END;

Thanks,

Sim
This post has been answered by BluShadow on Oct 31 2019
Jump to Answer
Comments
Post Details
Added on Oct 31 2019
7 comments
517 views