call oracle stored procedures from C#
i am writting stored procedure with one one cursor parameter which is of out direction.
procedure getAssetCategory(p_cursor out Cursor_Type.cursor_type )
open p_cursor for select distinct asset_category, asset_category_desc from asset_category;
i want to calling this stored procedure in my application...
can anybody help me how to write code for this.