Re: Calling functions...

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 03 Sep 1999 13:35:40 GMT
Message-ID: <37cfce3e.2811933@netnews.worldnet.att.net>

On Thu, 02 Sep 1999 18:47:37 GMT, ropru_at_my-deja.com wrote:

>IF year LIKE '1999/2000' THEN
>foo(v_id, v_examount);
>END IF;
>RETURN 1;
>END doit;
>/
>
>where "foo" is another function. I got error message that:
>
>"PLS-00221: 'FOO' is not a procedure or is undefined"

Your syntax looks incorrect. If FOO is a function, than you need to assign its return value to a variable. For example:

if year like '1999/2000' then

    x := foo(vid, vaxamount);
end if;

Looking at the error you got, this may be the problem.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Fri Sep 03 1999 - 08:35:40 CDT