PwC interview question

Write a Stored Procedure get user input and if the data type doesn't match perform error handling