oracle function return array of varchars, in c#

Question

I've to use an oracle function that returns an array of strings in a c# webapi. I don't realy have an idea on how to do this. I've started with the following code:

using (var cmd = _connection.CreateCommand()) 
{
    cmd.CommandType = CommandType.Text;
    //dual is temporary table where data is stored?!
    cmd.CommandText = "select Test_mp.f_loten(:p_item)  from dual";
    var p = cmd.Parameters;
    p.Add("p_item", 12942);
    _connection.Open();
    var rd= await cmd.ExecuteReaderAsync();
}

An example with an array as an input parameter: stackoverflow.com/questions/29605713/… — MT0
– MT0, Commented Dec 12, 2016 at 9:57
Oracle's documentation for passing arrays using C# ODP.NET oracle.com/technetwork/issue-archive/2007/07-jan/… — MT0
– MT0, Commented Dec 12, 2016 at 9:59

Timvr01 · Accepted Answer · 2016-12-14 14:37:38Z

0

The problem was my return type which was a custom Oracle type.

answered Dec 14, 2016 at 14:37

Timvr01

4964 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

oracle function return array of varchars, in c#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related