1 Reply Latest reply: Jan 1, 2013 10:44 PM by vladodias RSS

    RowSet Column Type Mismatch Error.

    981208
      Hi

      My problem is the SQL DB returns a column as "DATE" type in XSD the element is as follows

      <element name="Status_DATE" db:type="CHAR" minOccurs="0" nillable="true">
      <simpleType>
      <restriction base="string">
      <maxLength value="10"/>
      </restriction>
      </simpleType>
      </element>



      but the Jdeveloper throws the following error.


      "Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'DemoDA1' failed due to: RowSet Column Type Mismatch Error. The SQL type in the XSD (VARCHAR) does not match the SQL type in the RowSet (date) for column Status_DATE of parameter RowSet0. This procedure returns a RowSet which could in theory return any arbitrary result ".

      Any help will be much appreciated.

      Thank You