RESULT_CACHE option not recognized
Status: Alpha
Brought to you by:
altumano
A function like:
...
function getCharWaarde ( p_naam in t_instelling_naam
, p_ple_id in t_productline default bbx_session.get_ple_id
, p_wmj_id in t_werkmaatschappij default null
)
return t_instelling_char
RESULT_CACHE
;
...
Failes with (reason RESULT_CACHE option):
net.sourceforge.pldoc.parser.ParseException: Encountered "RESULT_CACHE" at line
45, column 3.
Was expecting one of:
";" ...
"%" ...
"@" ...
"AS" ...
"DETERMINISTIC" ...
"IS" ...
"PARALLEL_ENABLE" ...
"PIPELINED" ...
"." ...
Also take RELIES_ON clause into account:
ParseException at package <PMD_WideTables.pls>: net.sourceforge.pldoc.parser.ParseException: Encountered "RELIES_ON" at line 1356, column 49.
Was expecting one of:
";" ...
"AGGREGATE" ...
"AS" ...
"AUTHID" ...
"DETERMINISTIC" ...
"IS" ...
"PARALLEL_ENABLE" ...
"PIPELINED" ...
"RESULT_CACHE" ...
failes for function like
FUNCTION getValue(KEY IN T_SETTINGS.SET_KEY%TYPE)
RETURN T_SETTINGS.SET_VALUE%TYPE
RESULT_CACHE RELIES_ON(T_SETTINGS) IS
result T_SETTINGS.SET_KEY%TYPE;
BEGIN
SELECT SET_VALUE INTO result FROM T_SETTINGS WHERE SET_KEY = KEY;
RETURN result;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN NULL;
END getValue;