OK, since you haven't posted your code, I'll guess that you chose to change either your proc's parameter or the variable that you passed it to, to a NUMBER datatype and didn't make it big enough to hold the number of digits. Don't do that. Remember, the example that I posted was just that, an example. Stick with the VARCHAR2. If you want to catch the too big error by your own exceptions, you need to make sure that that string can handle many more characters (as I said before, just test the parameter).
Feel free to post the code that you are using.
Does this mean oracle has a predefined common exception that is catching. For a value that is too large for its container? Or that my Exception isn't catching?
That is exactly what it means. You have tried to put a value into a variable that does not 'fit' into that variable.
I followed your advice.
extra_digits EXCEPTION; -- Number must be a 10 digit number. Please enter 10 digits
no_digits EXCEPTION; -- Please enter digits there were no digits inputed.
invalid_char EXCEPTION; --You have entered an inappropriate character please enter number values 0-9.
less_digits EXCEPTION; --You have entered too few digits. Please enter a 10 digit phone number.
WHEN LENGTH(p_phne_no) > 10 THEN
You have entered too many digits. Number must be a 10 digit number. Please enter 10 digits.
Disconnecting from the database
Glad you got it working