Hi,
I'm using OraDirect.NET version 4 in VS2005 on Windows Vista. I have a problem with the DataSet Wizard.
I created an oracle function with the following definition:
FUNCTION report_procedures.ka1 (
datefrom IN DATE,
dateto IN DATE,
gb IN INTEGER,
st IN INTEGER,
kst IN INTEGER,
gw IN INTEGER
) RETURN curs;
curs is of type REF CURSOR.
In the DataSet Wizard I can see this function next to all the tables of the Schema I logged on to. I select it, the checkbox 'Share Connection' is set and the Data Source Type is 'Table Adapters'. When I press next, I always get the error "Cannot derive parameters for stored procedure".
If I do not use the DataSet Wizard, but instead create a dataset through code, the function works.
Here's a sample of the C# code is use:
OracleConnection conn = new OracleConnection();
conn.Direct = true;
conn.Server = "orion";
conn.UserId = "dec";
conn.Password = "berlin";
conn.Sid = "dev";
conn.Port = 1521;
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "report_procedures.ka1";
cmd.Parameters.Add("datefrom", new DateTime(2007, 4, 30));
cmd.Parameters.Add("dateto", new DateTime(2007, 5, 6));
cmd.Parameters.Add("gb", DBNull.Value);
cmd.Parameters.Add("st", 5);
cmd.Parameters.Add("kst", DBNull.Value);
cmd.Parameters.Add("gw", DBNull.Value);
OracleParameter par = new OracleParameter();
par.ParameterName = "data";
par.Direction = ParameterDirection.ReturnValue;
par.OracleDbType = OracleDbType.Cursor;
cmd.Parameters.Add(par);
cmd.ExecuteNonQuery();
OracleCursor oc = cmd.Parameters["data"].Value as OracleCursor;
OracleDataAdapter da = new OracleDataAdapter();
DataSet dataSet_KA1 = new DataSet();
da.Fill(dataSet_KA1, oc);
conn.Close();
Can anyone help me?
Best Regards
Marc Vanhoecke
DataSet Wizard - Cannot derive Parameters for stored procedure
-
marc.vanhoecke
- Posts: 11
- Joined: Mon 27 Aug 2007 08:24