Invalidating package


09-Apr-2017 14:54

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.

invalidating package-26

Random cam video chat gratis en vivo

object_type, object_name

= 'PACKAGE BODY' union select 'alter package '



We still have the same features and services available via this portal, with a few changes to the free sex chat rooms.… continue reading »


Read more