Hi, Periodically, I observe that some of the stored procedures become invalid.
There have been no changes to the tables, or to the stored procedure. Is there a way to see "why" a stored procedure is invalid ?
The following function computes Fibonacci numbers and illustrates the usefulness of memoization.
Because the function definition is recursive, the intermediate results can be looked up rather than recalculated at each level of recursion, which reduces the runtime drastically.
Which one is optimal depends on how the dependency graph looks like.object_type, object_name
= 'PACKAGE BODY' union select 'alter package '