This is my code-
code
error-
number or types of arguments are calling =
i think it’s a syntax error. i am getting same error in most of my codes
>Solution :
Wrong syntax.
SQL> CREATE OR REPLACE FUNCTION comparisonlike (g IN VARCHAR2)
2 RETURN VARCHAR2
3 AS
4 BEGIN
5 RETURN CASE WHEN MOD (g, 2) = 0 THEN 'EVEN' ELSE 'ODD' END;
6 END;
7 /
Function created.
SQL> select comparisonlike(25) result from dual;
RESULT
--------------------
ODD
SQL> select comparisonlike(12) result from dual;
RESULT
--------------------
EVEN
SQL>