PwC Interview Question

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