LLBLGEN 3.0
.NET Framework 2.0
LLBLGEN Release Date 3d December
Winform Application
oracle 9i/10g
I have problem returing resultset to datatable. I have stored procedure which returns three output which I need in datatable.
LLBLGEN Code generated is
public static DataSet Blockmemberdata(System.DateTime dt, System.String pMemberId, System.String pUserid, System.String pEmployeeId, System.String pCorporateId, System.String pAffiliatememberId, System.String pAffiliateclubId, IDataAccessCore dataAccessProvider)
{
using(StoredProcedureCall call = CreateBlockmemberdataCall(dataAccessProvider, dt, pMemberId, pUserid, pEmployeeId, pCorporateId, pAffiliatememberId, pAffiliateclubId))
{
DataSet toReturn = call.FillDataSet();
return toReturn;
}
}
I am calling this using the following line
DataSet resultSet = RetrievalProcedures.Blockmemberdata(transactiondate, memberid, null, null, null, null, null);
but resultset is empty. But If I execute the stored procedure using SQLPLUS with command exec SP_BLOCKMEMBERDATA(transactiondate, memberid, null, null, null, null, null); I get the ouput.
What is the reason that I am not getting the ouput using LLBLGEN ?
