[castor-dev] FIELDS AND STORED PROC

[Gustavo Pistoia]

Title: FIELDS AND STORED PROC

Hi
  Is there any way to map for a field but a stored procedure for an object?
  Example:
    CALL SQL select * from articles_by_company AS articlesByCompany

    but any codExtVisual must be STORED_PROC_DO_SOMETHING(codExtVisual).

    <xs:element name="article">
          <xs:complexType>
            <xs:sequence>
            <xs:element name="id" type="xs:integer"/>
            <xs:element name="codExtVisual" type="xs:string"/>
                ....
            </xs:sequence>
        </xs:complexType>
    </xs:element>

    <xs:element name="articlesByCompany">
        <xs:complexType>
            <xs:sequence>
                <xs:element name="company" type="xs:integer"/>
                <xs:element ref="articulo"/>
            </xs:sequence>
        </xs:complexType>
    </xs:element>

   Thanks !!!! Write your address down to send the money... jeje...