Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Please Help: Check to see if a string is a valid number in proced ure/function.
Is there a way to gracefully check to see if a string can be converted
to a number in a procedure or function? I have tried using the
TO_NUMBER(), but that just dies when I send it a string with letters in
it. Is there a way to trap that error, or another way to check to see
if a string is a valid number? Thank you.
Justin Received on Mon Aug 16 1999 - 15:40:24 CDT