Re: Q: pl/sql function question ?

Hy

As you can see from the error output, the Oracle error code is "ORA-06502: PL/SQL: numeric or value error", whereas in your EXCEPTION area you are checking for the predefined EXCEPTION "INVALID_NUMBER" corresponding to the Oracle error code -1722.

Modify your EXCEPTION code adding a new EXCEPTION handler for the right error code.

Hope this helps

Ciao Gennaro

tedchyn_at_yahoo.com wrote:

> Sir, following error messages were received when I tried to execute
> following procedure:
> ERROR at line 1:
> ORA-06502: PL/SQL: numeric or value error
> ORA-06512: at "SCOTT.IS_NUMBER", line 5
> ORA-06512: at line 10
>
> Qestion:
> 1. why false is not returned by is_number function ? procedure stop
> when first invalid_number is encoutered ?

>
> Thanks in advance Ted Chyn
> =======
> CREATE OR REPLACE FUNCTION is_number (str IN VARCHAR2)
> RETURN BOOLEAN
> IS
> v_num NUMBER;
> BEGIN v_num := TO_NUMBER (str);
> RETURN TRUE;
> EXCEPTION
> WHEN INVALID_NUMBER
> THEN RETURN FALSE;
> END;
> =============
Received on Mon Sep 06 1999 - 05:51:09 CDT