I'm trying to define an Oracle function that only accepts a NUMBER with a precision of, at most, 2 digits:
create or replace FUNCTION ftest(x NUMBER(2)) RETURN NUMBER IS BEGIN RETURN 42; -- body of function is not relevant for this question END;
However, it does not compile:
Error(1,24): PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , @ % default character The symbol ":=" was substituted for "(" to continue.
How can I fix
ftest's definition to only allow an input
NUMBER of precision 2?