1 Reply Latest reply on Jan 2, 2013 4:44 AM by vladodias

    RowSet Column Type Mismatch Error.


      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">
      <restriction base="string">
      <maxLength value="10"/>

      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