SQL & PL/SQL

Hi everybody,

Can you help me understand what I am doing wrong please ? I want to use an inline function within a view but I get an error.

Here is a code example :

WITH FUNCTION FormatString (operand VARCHAR2) RETURN VARCHAR2
IS
BEGIN
  RETURN INITCAP(operand) ;
END ;

SELECT FormatString('example') FROM DUAL

The above code returns the following error : 00905. 00000 -  "missing keyword"

Maybe I do something wrong.

Thank you for your help.

Best regards.

MS