I need to pass c# user defined object:
[DataContract]
public class SEmployeeIncome
{
[DataMember]
[OracleObjectMappingAttribute("CARDID")]
public string CardId { get; set; }
[DataMember]
[OracleObjectMappingAttribute("INCOMETIME")]
public string IncomeTime { get; set; }
}
as list to pl/sql function but oracle returns such error : {"Invalid parameter binding\r\nParameter name: p_employees_income"}
This is how i pass object list as parameter:
var oracleParam = new OracleParameter();
oracleParam.OracleDbType = OracleDbType.Array;
oracleParam.Direction = ParameterDirection.Input;
oracleParam.ParameterName = "p_employees_income";
oracleParam.Size = entity.EmployeesIncome.Count();
oracleParam.Value = entity.EmployeesIncome.ToArray() ;//SEmployeeIncome list
oracleCommand.Parameters.Add(oracleParam);
and pl/sql function definition as:
Function search_delayed_employees (p_employees_income employee_income )
return ics_types.result_cursor ;
ToArray().First()
to see if it accepts that – Dominic Cotton Jan 5 at 16:53