Re: Where to look to see if a proc/func/package is valid

From: justme <nobody_at_rogers.com>
Date: Thu, 03 Oct 2002 17:30:19 GMT
Message-ID: <L8%m9.132199$q41.44456@news02.bloor.is.net.cable.rogers.com>

select status from all_objects

                             user_objects
                             dba_objects

"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message news:AO_m9.10388$m92.2672659_at_news1.news.adelphia.net...
> 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:19 CDT

This message: [ Message body ]
Next message: Jusung Yang: "Re: [PL/SQL] getting cursor metadata"
Previous message: Ted Busky: "Re: Silent Install Won't Run"
In reply to: Scott Mattes: "Where to look to see if a proc/func/package is valid"
Next in thread: Brian Peasland: "Re: Where to look to see if a proc/func/package is valid"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US