Re: package to check if the input chars are number

if the package/procedure/function isn't too large, overload it by creating a duplicate named proc/func where the only difference in the declaration is the parameter type. Then you can code each proc/func to do what you want...

At 02:03 AM 7/6/00 -0800, grace lim wrote:
>gurus,
>
>is there a package that can check if the input is a numeric or varchar when
>the variable has a varchar2 type?
>
>e.g. user input '123' === output is numeric
> '2rY' === output not numeric
>
>thanks
>
>
>
>Grace Lim
>Suy Sing Comm'l Corp.
>247-41-34
>--
>Author: grace lim
> INET: mglim_at_softhome.net
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Kenneth Komoto			Email: kgkomoto_at_ucdavis.edu
Office of the Registrar	Phone: (530)752-7197
University of California	Fax  : (530)752-0329