Problem Store Procedure in OutPut Parameter

[hariharanmca]

CREATE PROCEDURE sp_Insert_Prev_Date
(
@pCurDate smalldatetime,
@pFlgPrvDate integer,
@pOutDate smalldatetime output
)
as
declare @recCount integer, @recCount1 integer
begin
set @recCount = (select isnull(count(*),0) from tblTime_Setings)
If @recCount > 0
begin
If @pFlgPrvDate =1
begin
update tblPrv_Date_Setings set PrvDate= @pCurDate
set @pOutDate = @pCurDate
End
Else
Begin
set @recCount1 = (select isnull(count(*),0) from tblPrv_Date_Setings)
If @recCount1 > 0
begin
set @pOutDate = (select PrvDate from tblPrv_Date_Setings)
End
Else
Begin
insert into tblPrv_Date_Setings (PrvDate) values(@pCurDate)
set @pOutDate = @pCurDate
End
End
end
end

the Output parameter @pOutDate will not Return any Value to my frontend can any one know

[almaz]

You submitted SQL side but didn't show the code that runs this SP.
Did you set the SqlParameter.Direction of the corresponding parameter to ParameterDirection.Output?