title: Biztalk unable to read Oracle 18 stored procedure with strongly typed ref cursor
body: <p>We have Biztalk to read data from a table in Oracle by calling a stored procedure. The stored procedure returns a strongly typed cursor and it was working fine with Oracle 12. </p>
  
  <p>Updating to Oracle 18 is returning a response as if the cursor is weakly typed:
  <a href="https://docs.microsoft.com/en-us/biztalk/adapters-and-accelerators/adapter-oracle-database/message-schemas-for-ref-cursors" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/biztalk/adapters-and-accelerators/adapter-oracle-database/message-schemas-for-ref-cursors</a></p>
  
  <p>This link has the exact problem that we are facing, but the cursor is strongly typed.</p>
  
  <p>I tried returning a ref cursor using record and explicity specifying the column names and types. It did not work. The Biztalk version is 2013 R2. </p>
  
  <p>Has anyone encountered this problem with Oracle 18? Works fine with Oracle 12.</p>
  
  <p>The strongly typed cursor is </p>
  
  <pre><code>TYPE t_ReqCursor is REF CURSOR RETURN REQUEST%ROWTYPE
  </code></pre>
  
  <p>and what Biztalk is reading is something like this </p>
  
  <pre><code>&lt;GenRecordRow xmlns="http://Microsoft.LobServices.OracleDB/2007/03"&gt;
          &lt;GenRecordColumn&gt;
              &lt;GenRecordColumn&gt;
                  &lt;ColumnName&gt;AGNCY_RQST_ID&lt;/ColumnName&gt;
                  &lt;ColumnValue&gt;545&lt;/ColumnValue&gt;
                  &lt;ColumnType&gt;System.Int64&lt;/ColumnType&gt;
              &lt;/GenRecordColumn&gt;
              &lt;GenRecordColumn&gt;
                  &lt;ColumnName&gt;RQST_ID&lt;/ColumnName&gt;
                  &lt;ColumnValue&gt;4344&lt;/ColumnValue&gt;
                  &lt;ColumnType&gt;System.Int64&lt;/ColumnType&gt;
              &lt;/GenRecordColumn&gt;
  &lt;/GenRecordRow&gt;
  </code></pre>