Hello, thx for Your replly.
But my problem is that the value of OutParameter["ACCESS_GRANT"]
after execute query is null. I`ve problem only with out parameter. Other stored procedure without
out parameter work fine.
This is code of function generated by ORM, with out ":" in paramtere name.
public
static IQueryResult checkAuthorization(IObjectScope scope,int? iD_USER,int? iD_AUTHORIZATION,ref int? aCCESS_GRANT)
{
IQuery query = scope.GetSqlQuery("\"CHECK_AUTHORIZATION\" ?,?,?",null,"INTEGER ID_USER,INTEGER ID_AUTHORIZATION,OUT.INTEGER ACCESS_GRANT");
IQueryResult res = query.Execute(new object[] {iD_USER,iD_AUTHORIZATION,aCCESS_GRANT});
int a = res.Count;//Actually executes the query
aCCESS_GRANT= res.OutParameter[
"ACCESS_GRANT"] as int?;
return res;
}
Best regards