Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can a Table be Invalidated?
khatri wrote:
> Well Andreas, i feel there is a possibility that a table can be
> invalidated. Just think in reference to the following:
> If an object is referenced through a stored procedure then when you
> access that procedure all the referenced objects are compiled at run
> time. But in a later course, if you alter the procedure, at the time
> all the referenced objects are invalidated. Is this justifies that a
> table can be invalidated if referenced in a strored procedure? i don't
> know. just try.
>
A (relational) table can not reference procedure. If a table name occurs within a stored procedure it means, stored procedure references this table and not the table references that stored procedure. So if you alter a stored procedure, the table can not be invalidated.
Best regards
Maxim Received on Sat Jul 16 2005 - 06:20:38 CDT