C# Read Cursor inside refcursor(Oracle)

Question

I've got an oracle stored function that returns sys_refcursor as an out parameter. It's structure belike

Object

param1
param2
param3
param4_list(cursor)

I want to get param1-3 values into datatable1 and param4_list(cursor) values into datatable2 using C#. Any suggestions? If possible, show examples please.

Hasan Alizada · Accepted Answer · 2018-03-10 08:44:02Z

3

Currently, there is no support for nested cursors in ODP.NET. You'll have to take a different approach. e.g. returning the rows as XML or JSON instead of in a nested cursor. Read my question on AskTom.

edited Mar 10, 2018 at 8:44

answered Mar 9, 2018 at 8:08

Hasan Alizada

5914 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Filnor Over a year ago

This is a borderline link-only answer. You should expand your answer to include as much information here, and use the link only for reference.

Collectives™ on Stack Overflow

C# Read Cursor inside refcursor(Oracle)

Object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Object

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related