Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Please Help: Check to see if a string is a valid number in proced ure/function.

Please Help: Check to see if a string is a valid number in proced ure/function.

From: Justin J. Risser <JJRisser_at_lancasterlabs.com>
Date: Mon, 16 Aug 1999 15:40:24 -0500
Message-ID: <10907816B00AD211A93300A0C9B3BBE6021E5989@xdelta.lancasterlabs.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US