Hi there,
This method was definitely working for me yesterday and I can't seem to find out what I've changed that makes it return the following error today:
Unable to cast object of type 'System.String' to type 'Oracle.DataAccess.Client.OracleParameter'.
- public DataTable SearchDefault(string item, string criteria)
-
{
-
using (OracleConnection oce = new OracleConnection(ConnectionString))
-
{
-
oce.Open();
-
DataTable ds = new DataTable();
-
-
OracleCommand command = new OracleCommand("SP_SEARCHCATS", oce);
-
command.CommandType = CommandType.StoredProcedure;
-
-
OracleParameter searchCriteria = new OracleParameter();
-
searchCriteria.ParameterName = "SearchCriteria";
-
searchCriteria.OracleDbType = OracleDbType.Varchar2;
-
searchCriteria.Direction = ParameterDirection.Input;
-
searchCriteria.Value = criteria;
-
command.Parameters.Add(searchCriteria); // ERROR THROWN HERE!
-
-
OracleParameter searchItem = new OracleParameter();
-
searchItem.ParameterName = "SearchItem";
-
searchItem.OracleDbType = OracleDbType.Varchar2;
-
searchItem.Direction = ParameterDirection.Input;
-
searchItem.Value = item;
-
command.Parameters.Add(searchItem); // ERROR ALSO THROWN HERE!
-
-
OracleParameter results = new OracleParameter();
-
results.OracleDbType = OracleDbType.RefCursor;
-
results.Direction = ParameterDirection.Output;
-
command.Parameters.Add(results);
-
-
OracleDataAdapter productsAdapter = new OracleDataAdapter(command);
-
productsAdapter.Fill(ds);
-
return ds;
-
}
Any ideas?
Matt
