i have query inside function result_cache.
so when table changed - cache invalidated , function executed again.
what want implement function depends only on input parameters, , doesn't depend on implicit dependencies (like tables, etc).
is possible (without dynamic sql)?
a function depends on parameters can declared deterministic. results of function cached in cases. thread on otn forums shows how deterministic function results cached inside sql statements.
as of 10gr2, function results don't cached across sql statements nor cached in pl/sql. still, cache feature can useful if call function in select might called lots of time.
i don't have 11gr2 instance available right now, can't test result_cache feature, have considered delaring function relying on fixed dummy table (a table never gets updated instance)?
Comments
Post a Comment