I've got an problem with adding parameters to ExecuteStoreQuery, I've always got an message "ORA-00936: missing expression"
I was using this code
Code: Select all
object[] Parameters =
{
new Devart.Data.Oracle.OracleParameter{ ParameterName = "@SysPRPRODUCT", Value = sysPrProdukt},
new Devart.Data.Oracle.OracleParameter{ ParameterName = "@SysBRAND", Value = ServiceValidator.SysBRAND},
new Devart.Data.Oracle.OracleParameter{ ParameterName = "@SysOBType", Value = sysObTyp},
new Devart.Data.Oracle.OracleParameter{ ParameterName = "@SysPRKGroup", Value = SysPRKGroup},
new Devart.Data.Oracle.OracleParameter{ ParameterName = "@SysPRHGroup", Value = PrHGroup.SYSPRHGROUP}
};
PrParamList = context.ExecuteStoreQuery("SELECT * FROM TABLE(CIC.CIC_PRISMA_UTILS.DeliverAvalPrParam(@SysPRPRODUCT, @SysBRAND, @SysOBType , @SysPRKGroup, @SysPRHGroup))", Parameters).ToList();