Re: Compilation error

From: Valery V. Tsekhmister <valery_tsekhmister_at_hotmail.com>
Date: Tue, 22 Jul 2003 13:27:13 +0400
Message-ID: <bfj00g$9p1$1@slim.sovintel.ru>

Hi !

You made 3 mistakes in your script: please see below in text :

"Alphomega (JLM)" <alphomega_at_free.fr> wrote in message news:3f1cfc40$0$8079$626a54ce_at_news.free.fr...
> Hi,
>
> I'm a really newbie with Oracle.
> I write :
>
> SQL> CREATE FUNCTION AFF_DPT(val DOUBLE PRESICION) RETURN VARCHAR(255) IS
> 2 BEGIN
> 3 IF val = 1 THEN
> 4 RETURN 'Moyenne';
> 5 /*ELSEIF*/ ELSIF val = -1 THEN
> 6 RETURN 'Inconnue';
> 7 ELSE
> 8 RETURN CAST((val - 1) AS CHAR);
> 9 END IF;
> 10
> 11 END;
> 12 /
>

To see errors while compilation you should invoke "show errors" sql*plus directive.

Regards !
Valery. Received on Tue Jul 22 2003 - 04:27:13 CDT