Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Where to look to see if a proc/func/package is valid
Look for the STATUS column in ALL_OBJECTS for your specific object in
question.
HTH,
Brian
Scott Mattes wrote:
>
> I can see the source in all_source, but how can I tell if it is 'valid'?
> TOAD, and other tools, show this, but where are they getting their info from
> ?
>
> Thank you.
Received on Thu Oct 03 2002 - 12:30:54 CDT