How to create store Procedure in oracle with asp.net c#

CREATE OR REPLACE PROCEDURE Country( Cur_User out SYS_REFCURSOR ) is begin open Cur_User for Select * from tblCountry; end; -------------------------------------------------------------------------- public void DataBindingGridView() { string DBConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; using (OracleConnection con = new OracleConnection(DBConnection)) { using (OracleCommand cmd = new OracleCommand()) { string Query = "Country"; cmd.Connection = con; cmd.CommandText = Query; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Cur_User", OracleDbType.RefCursor).Direction = ParameterDirection.Output; con.Open(); OracleDataAdapter da = new OracleDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); } } } Ref: https://www.c-sharpcorner.com/article/calling-oracle-stored-procedures-from-microsoft-net/