Re: Ora8 equivalent of ALL_PROCEDURES

all_objects where object_type='PROCEDURE'

On Fri, 11 Feb 2005 17:09:03 +0100, "Martijn Tonies" <m.tonies_at_upscene-removethis.nospam.com> wrote:

>Hi,
>
>Can anyone tell me the Oracle 8 equivalent of ALL_PROCEDURES where I can
>find Stored Procedure info?
>
>Or is there none and should I use ALL_OBJECTS without the extra columns
>found in
>ALL_PROCEDURES in Oracle 9 and 10?
>
>--
>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
>Server
>Upscene Productions
>http://www.upscene.com
>
>
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Feb 11 2005 - 11:11:08 CST