LLBLGEN 3.0 rel 18/8/2010
Oracle 9i/10g
I had created stored procedure in Oracle and had generated the same with LLBLGEN.
string message;
var affiliateclub = new AffiliateclubEntity();
const string generateAffiliateclubno = "";
Convert.ToString(ActionProcedures.ReturnAffiliateclubno((ref generateAffiliateclubno)));
Problem:
ref generateAffiliateclubno is not at all accepting and project is not getting complied because it says type or name space name expected. As far as name space is concerned I have declared using ClubCentricHelper.DatabaseSpecific;
And I can see the LLBLGEN code also in related namespace referring what i have coded
public static int ReturnAffiliateclubno(ref System.String generateAffiliateclubno)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return ReturnAffiliateclubno(ref generateAffiliateclubno, dataAccessProvider);
}
}
public static int ReturnAffiliateclubno(ref System.String generateAffiliateclubno, IDataAccessCore dataAccessProvider)
{
using(StoredProcedureCall call = CreateReturnAffiliateclubnoCall(dataAccessProvider, generateAffiliateclubno))
{
int toReturn = call.Call();
generateAffiliateclubno = call.GetParameterValue<System.String>(0);
return toReturn;
}
}
private static StoredProcedureCall CreateReturnAffiliateclubnoCall(IDataAccessCore dataAccessProvider, System.String generateAffiliateclubno)
{
return new StoredProcedureCall(dataAccessProvider, "\"BCLUB1868\".\"SP_AFFILIATECLUBNO\"", "ReturnAffiliateclubno")
.AddParameter("RETURN_VALUE", "VarChar", 4000, ParameterDirection.ReturnValue, true, 0, 0, generateAffiliateclubno);
}
Not sure what is causing the problem
