C# and PlSql Cursor

Question

I have a Pl/Sql procedure signature that look like this

foo(param1 IN type1, param2 IN type1, c OUT REF CURSOR).

This stored procedure is being called in C#. In the C# code, I fill a DataTable with this cursor. I would like to know when the cursor will be closed.

Should I close it in the SP? In the code? Or is the object OracleRefCursor will close it when I'll call the Dispose method(cause it has no Close method)?

Thanks

Edit : Here is some example of the code I'm using

Stored proc :

create or replace procedure foo1(param1 IN type1, param2 IN type1, c OUT REF CURSOR)
IS
BEGIN
    OPEN c
    FOR
       SELECT x
       FROM table;
END;

create or replace procedure foo2(param3 IN type1, param4 IN type1, c OUT REF CURSOR)
IS
   temp type1 := param3;
   x type1;
BEGIN
   LOOP temp < param4
      foo1(temp, param4, c);
      FETCH c INTO x;
      temp := temp +1;
   END LOOP;
END;

Thanks

do you have some example of working with c# and plsql cursor? because i have posted question recently nobody answered — Yevhen
– Yevhen, Commented Jan 13, 2010 at 13:48
Can you show me some c# sample? Because I have problem with reading from Cursor with DataReader. There ara many examples with DataAdapter but none with DataReader. Thanx in advance. — Yevhen
– Yevhen, Commented Jan 13, 2010 at 14:10
I'm using a DataAdapter.Fill() method to fill a DataTable with the cursor. — ALOToverflow
– ALOToverflow, Commented Jan 13, 2010 at 14:25

Yevhen · Accepted Answer · 2010-01-13 13:50:57Z

0

You should not close cursor because no data will be returned, you have to close it in your c# code.

answered Jan 13, 2010 at 13:50

Yevhen

1,9752 gold badges14 silver badges27 bronze badges

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

2 Comments

ALOToverflow Over a year ago

But how? I use a OracleRefCursor object to store the cursor but there is no such ting as a close method on this object. Only a dipose().

Yevhen Over a year ago

view my topic there are some explorations about it stackoverflow.com/questions/2037000/c-and-postgresql

Collectives™ on Stack Overflow

C# and PlSql Cursor

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related