select query using cursors

[bala venkata siva ram kum]

hi friends,
this is balu.here i am using oracle 10g.i need to call records from database using procedures.so i created ref cursor in package.package and package body is created successfully.but i don't know how to call this from my application code(in .net using c#).i need to display these values in gridview.please send me the solution. here is my code.

create or replace package pkg1
as
 type t_cursor is ref cursor;
 procedure get_employee(cur_employees out t_cursor);
end pkg1;
 

create or replace package body pkg1
as
 procedure get_employee(cur_employees out t_cursor)
 is
 begin
  open cur_employees for select * from emp;
 end get_employee;
end pkg1;
 

[amitpatel66]

You have posted your question in the wrong forum. This is an oracle forum and do post your oracle queries in this forum and we would be happy to help.

Moderator