Hi am doing a custom modules in DotNetNuke with AcuitiDP OracleDataProvider. This module is previously in SQL Server and I have converted almost everything in Oracle except for the ExecuteScalar method I am having problem with.

Below is my stored procedure and the executescalar i used to call. hope someone can help me over here.

--******************************************************
--************ GetEventCountByDate
--******************************************************
///---
create or replace
procedure {objectQualifier}GetEventCountByDate
(
p_Date in timestamp,
returnValue out number
)
is
begin
select count(*) into returnValue from {objectQualifier}TBL_Event where p_Date between START_TIME_DT and END_TIME_DT;
end;
///---



public override int GetEventCountByDate(DateTime date)
{
            OracleSqlHelper OracleSqlHelper = new OracleSqlHelper();
            return int.Parse(OracleSqlHelper.ExecuteScalar(ConnectionString, ObjectQualifier + "GetEventCountByDate", date, "returnValue").ToString());
}