Hi

iam using asp.net and c# and oracle,

in my app i created one stored procedure

CREATE OR REPLACE
PROCEDURE GetCustDetails(p_recordset1 OUT SYS_REFCURSOR) AS
BEGIN
  OPEN p_recordset1 FOR
  SELECT *
    FROM CUST_INFO_TABLE;
END GetCustDetails;

now i call this stored procedure in my app like this..

OdbcCommand cmd = new OdbcCommand("GetCustDetails", cn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(new OdbcParameter
        ("reccount", OdbcType.Cursor)).Direction = ParameterDirection.Output;

here actually i need to give curser type,but i didn't have that datatype.

but if i go for Oracle name space its available for me..
              
                objCmd.Parameters.Add("GetCustDetails", OracleType.Cursor).Direction = ParameterDirection.Output;

i haven't find curser type in odbc,

        OdbcDataAdapter da = new OdbcDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "cust");
        GridView1.DataSource = ds.Tables["cust"];
        GridView1.DataBind();

now which way i can solve my problem,mainly my intenstion is getting all the custmersdetails from the table through odbc,i know normal method like to sending query through odbcdataadapter,but i need to use stored procedure,

please give me any samples available..

regards
ganaparthi