Hello,
I am trying to call an Oracle SP in my c# code. But I am having messages like:
wrong number or types of arguments in call to 'SP_COUNTRY_SELECT_CRUD'
below are c# code:
private DataSet GridBinder()
{
string constr = ConfigurationManager.ConnectionStrings["OracleConnectionStringCommon"].ConnectionString;
DataSet dt = new DataSet();
using (OracleConnection con = new OracleConnection(constr))
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = con;
cmd.CommandText = "COUNTRY_PACKAGE.SP_COUNTRY_SELECT_CRUD";
cmd.CommandType = CommandType.StoredProcedure;
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
adapter.Fill(dt);
}
}
return dt;
}
private void mycountryGridBinder()
{
GridView1.DataSource = GridBinder();
GridView1.DataBind();
}
ORACLE SP code:
PROCEDURE SP_COUNTRY_SELECT_CRUD (cur OUT SYS_REFCURSOR) AS
BEGIN
OPEN cur FOR SELECT * FROM Country;
END SP_COUNTRY_SELECT_CRUD;
Country table has two only column fields: Code & Description.