Compilation error

Hi,

I'm a really newbie with Oracle.
I write :

SQL> CREATE FUNCTION AFF_DPT(val DOUBLE) RETURN VARCHAR(255)   2 BEGIN
  3 IF val = 1 THEN
  4 RETURN 'Moyenne';
  5 ELSEIF val = -1 THEN
  6 RETURN 'Inconnue';
  7 ELSE
  8 RETURN CAST((val - 1) AS CHAR);
  9 END IF;
 10
 11 END;
 12 /

SqlPlus respond:

Attention : Function created with compilation errors.

Can you help me to find the problem please ?

Jean-Luc ! Received on Tue Jul 22 2003 - 03:56:32 CDT