why database was not refresh?

My stored procedure is here
and tell me how to added refresh database code

CREATE Procedure [dbo].[InsertUpdateDelete_customer]
(
@cust_id int,
@cust_name nvarchar(max),
@cust_address nvarchar(max),
@contact_number nvarchar(11),
@cust_type nvarchar(10),

@Param int,
@Output varchar(20) output
)
As
Begin
if(@Param=1)
Begin
if exists(select cust_id from customer where cust_name=@cust_name)
Begin
set @Output='Already Exist'
End
Else
Begin
--if(@Error=0)
--Begin
insert into customer
(
cust_id,
cust_name,
cust_address,
contact_number,
cust_type

)
values
(
@cust_id,
@cust_name,
@cust_address,
@contact_number,
@cust_type
)
set @Output='Inserted'
--End
--Else
--begin
-- set @Error=2
-- print @Error
--End
End

End

if(@Param=2)
Begin
Update customer
set cust_name=@cust_name,

cust_address=@cust_address,
contact_number=@contact_number,
cust_type=@cust_type,

where customer_id=@customer_id or cust_name=@cust_name
set @Output='Updated'
End

if(@Param=3)
Begin
Delete From customer
where customer_id=@customer_id or cust_name=@cust_name
set @Output='Deleted'
End
End


this stored procedure is exixuted but not refresh database it need to refresh database amualy.