Hi
I'm trying to implement a function that will be called within a sql command (cursor), but when placing the function in the header it says that it is not possible to implement
show me error
Error: PLS-00999: implementation restriction (may be temporary) RELIES_ON clause is disallowed on function declaration
IN header I tried It
FUNCTION FNC_RET_SAMPLE(P_ID IN MYTABLE.ID%TYPE) RETURN NUMBER RESULT_CACHE RELIES_ON (MYTABLE);
instead of this to make a cache ,I thought about using DETERMINISTIC FUNCTION, passing ROWID from the table, would it work?
FUNCTION FNC_RET_SAMPLE(P_ID IN MYTABLE.AIE_ID%TYPE, P_ROWID IN ROWID ) RETURN NUMBER DETERMINISTIC RESULT_CACHE;
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production