2009-10-12

Result-Cached Function

Due to the Automatic Detection of Data Sources of Result-Cached Function in Oracle 11R2 this is the code I'm doing in my 10r2 environment to prepare it for a 11R2 (or future migration. I will not prepare it to 11R1 :-) )



$IF (dbms_db_version.version=11 and dbms_db_version.release>1)
OR dbms_db_version.version>11
$then
RESULT_CACHE
$END
IS (...)



For instance in the package SPEC
(...)
FUNCTION get_name( pv_cod IN varchar2 )
RETURN varchar2
$IF (dbms_db_version.version=11 and dbms_db_version.release>1)
OR dbms_db_version.version>11
$then
RESULT_CACHE
$END;
(...)



And also in the package BODY

(...)
FUNCTION get_name( pv_cod IN varchar2 )
RETURN varchar2
$IF (dbms_db_version.version=11 and dbms_db_version.release>1)
OR dbms_db_version.version>11
$then
RESULT_CACHE
$END
IS (...)

No comments:

Post a Comment

Os comentários são moderados.
The comments are moderated.