Skip to Main Content

General Development Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Oracle.ManagedDataAccess.Core unsopported column type CURSOR

user-a07enFeb 15 2023

Hi,

in my .net6 app I've a query with the following construct inside the select:

SELECT rs.id,
                             rs.id_pratica_origine,
                             p.data_affidamento, 
                             p.data_fine_aff, 
                             tsg.descrizione as desc_stato_gesto
                             CURSOR(SELECT * FROM TABLE(motivi_nt)) AS motivi,
                             attivita_riscontro,
                               …
                             FROM .....
                             WHERE

When I try to make "command.ExecuteReader()", I've the error in the title “unsopported column type”.

The problem is with the construct CURSOR.

I searched how can I manage a CURSOR in the query, but I did not find anything.

I cannot change the query because it has been written many years ago and works well, besides the method I'm using to manage this kind of query is in a library, so it should be exposed to other classes.

The code worked with the library Devart, but now it does not work anymore-

Do you have any suggestion?

My intent is to make a recursive method to get all the “nested tables” inside a query and transform them with a mapper to a POCO object, where the “nested tables” in this case are given by CURSOR construct.

I know there is a REF CURSOR in Oracle.ManagedDataAccess.Core, is it possible to use that instead of the CURSOR?

Thanks.

This post has been answered by Alex Keh-Oracle on Feb 15 2023
Jump to Answer
Comments
Post Details
Added on Feb 15 2023
3 comments
61 views