Adriano,

I'm not so sure I like the inheritance of the "not null" properties of
the DOMAIN.

Does that mean that I will get a runtime error if a null is assigned to
the value inside the SP? Or, only if a null is passed/returned from the
SP?

> When a domain change, should be necessary to invalidate the procedure
> cache.
> Could be done using the stored dependencies.

How do you propose to mark the procedure as "invalidated"?

What if the change to the domain means that the SP is not recompilable?

What happens if the SP source has been deleted, only the BLR is
available?

Could this "invalidation" be used to allow for SP's to be dropped
completely?


Sean