Filling a ref cursor

How to fill a refcursor with dataset in C#.

i want to pass a dataset as parameter and fill a refcursor with the same dataset.

Showing Answers 1 - 3 of 3 Answers

viv_mca
Profile Answers by viv_mca

Jul 31st, 2008

you need to use ODP.Net connector.
In OracleCommand object add OracleParameter object with following properties
OracleDbType = OracleDbType.RefCursor;
Direction= ParameterDirection.Output;
give the name of your stored procedures's refcursor parameter name