Which two conditions must be true for a PL/SQL function to be result cached? (Choose two.)
A.
It must be part of a package.
B.
It must be a pipelined table function.
C.
It must not be defined in an anonymous block.
D.
It must have at least one OUT or IN OUT parameter.
I disagree with D.
To be result cached a function cannot have OUT or IN OUT parameters:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/subprograms.htm#LNPLS701
Is thia a case of Unscored Questions?
Agree, only C is correct.
C
HY GUYS WHY D ?
create or replace function my_funct (p_you varchar2 default ‘GUYS’)
return varchar2
result_cache
is
begin
v_txt varchar2(30) := ‘HY ‘ || p_you;
return v_txt:
end;
this one is cached isnt’it ? no parameters…. ????