I tried to call a stored procedure in my programm through the DatabaseModel, but I always get the following NullReferenceException: "Object reference not set to an instance of an object."
I describe you the way how I tried:
1) Create an Oracle Procedure with one parameter (defined as OUT parameter) for getting back a result. (It's not possibly to use Oracle Functions)
2) Create a ORM Database Model (.rlinq) where I inserted my procedure. In the cs-File there was the following autogenerated code:
public object PCCHECKSESSIONS(string pSRESULT)
SqlParameter parameterPSRESULT = new SqlParameter("PS_RESULT", OpenAccessType.Varchar, ParameterMode.Out);
> sqlParameters = new List<
object queryResult = this.ExecuteStoredProcedure<
>("'PC_CHECK_SESSIONS' ?", sqlParameters ,pSRESULT);
3) Now I tried to call my procedure via the databaseContext
string p_param = "";
var res = HugeObjectHolder.dbContext.PCCHECKSESSIONS(p_param);
4)When I now call the procedure I get the Errormessage (NullReferenceException: "Object reference not set to an instance of an object."
What do I have to do, that I can call my procedure and also get my OUT parameter????
Thanks for you answer.