By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,224 Members | 1,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,224 IT Pros & Developers. It's quick & easy.

select query using cursors

P: 15
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.
Expand|Select|Wrap|Line Numbers
  1. create or replace package pkg1
  2. as
  3.  type t_cursor is ref cursor;
  4.  procedure get_employee(cur_employees out t_cursor);
  5. end pkg1;
  6.  
Expand|Select|Wrap|Line Numbers
  1. create or replace package body pkg1
  2. as
  3.  procedure get_employee(cur_employees out t_cursor)
  4.  is
  5.  begin
  6.   open cur_employees for select * from emp;
  7.  end get_employee;
  8. end pkg1;
  9.  
Jul 14 '10 #1
Share this Question
Share on Google+
1 Reply


amitpatel66
Expert 100+
P: 2,367
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
Jul 15 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.