Re: can't invoke function (PL/SQL)

Since my site isn't using the latest versions of Oracle or PL/SQL, there is a chance that this answer doesn't apply to later releases.

It looks to me as though the only problem is with the way that you're using your function.

You can't reference your own stored functions in a SELECT command. The first time I ran into this I thought it was a silly restriction. Maybe OracleCo has fixed this by now.

I think can only call your stored functions by using PL/SQL, like this:

        c := IsNumeric('1');

Hope this helped.

Michael Agbaglo wrote:
>
> I compiled the function below in Oracle for Win95
>
> CREATE OR REPLACE FUNCTION IsNumeric( C IN CHAR ) RETURN BOOLEAN
> IS
> BEGIN
> RETURN ( C >= '0' AND C <= '9' );
> END;
>
> I verified it with ...
>
> SELECT object_type, object_name,status
> FROM user_objects
> WHERE object_type = 'FUNCTION'
>
> --> valid !
>
> I did a
>
> SELECT IsNumeric('p') FROM DUAL;
>
> and got an error: no such column ... or similar...
>
> WHY?
 

-- 
The views expressed here are mine and do not reflect the official
position of my
employer or the organization through which the Internet was accessed.