Error Handling in Sql

Question

I want to handle error while insertion in the table if wrong value is inserted it will throw an error,for this I have written following stored procedure 

 

 

ALTER PROCEDURE [dbo].[Insert_Update_Test]

(

@Para varchar(50)='',

@Name varchar(50)='',

@Id int = 0

)

AS

BEGIN

Begin Try

If @Para = 'ADD'

Begin

Insert into tblTesters (Name,Id) values (@Name,@Id)

END

End Try

Begin Catch

Select ERROR_NUMBER()

END Catch

END

If I am Executing this Store Procedure 

EXEC Insert_Update_Test 'ADD','1','Aniket'

If am passing value varchar to integer parameter @Id,but catch blog is not getting executed even if there is error while insertion

Please do let me know about the solution I am stuck upon this