oracle存储过程返回多条记录

oracle存储过程返回多条记录

create table userTabel(

userid number(10),

username varchar2(100),

constraint PK_USERID PRIMARY KEY(userid)

);

commit;

insert into userTabel values(1,'Albert');

insert into userTabel values(2,'reboot') ;

insert into userTabel values(3,'Jeff');

--创建包以游标的形式返回userTabel的结果集

create or replace package pkg_AA is

-- Author : ADMINISTRATOR

-- Created : 2008-07-17 8:35:52

-- Purpose :

-- Public type declarations

type mycur is ref cursor;

procedure fun_GetRecords(cur_return out mycur);

end pkg_AA;

create or replace package body pkg_AA is

-- Function and procedure implementations

procedure fun_GetRecords(cur_return out mycur)

is

begin

open cur_return for select * from Usertabel;

end fun_GetRecords;

end pkg_AA;

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.OracleClient;

public partial class OracleCursor_Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

this.BindGridView();

}

}

private void BindGridView()

{

OracleConnection

conn = new OracleConnection(ConfigurationManager.ConnectionStrings[\"Connec

tionString\"].ConnectionString);

OracleCommand

comm = new OracleCommand(\"pkg_AA.fun_GetRecords\

comm.Parameters.Add(\"cur_return\

OracleType.Cursor).Direction = ParameterDirection.Output;

comm.CommandType = CommandType.StoredProcedure;

DataSet ds = new DataSet();

using (OracleDataAdapter da = new OracleDataAdapter(comm))

{

da.Fill(ds);

}

this.GridView1.DataSource = ds.Tables[0].DefaultView;

this.GridView1.DataBind();

}

}