Re: Querying stored procedures

David Gibson wrote:

> Hello,
>
> I'm tyring to verify that stored procedures haven't changed. Ideally, I'd
> like to automate a query that lists stored procedures and stores them in a
> file, that I can check with diff and/or a hash value. Would anyone know of
> the syntax for such an animal?
>
> Also, I know I can store the syntax for a query like this, and schedule
> the query from cron, etc. It's been a while though, so I've forgotten the
> syntax for executing a stored query without going into the sql app- it
> was something like:
>
> isql [database and user parameters] < query.sql
>
> Is that right?
>
> Any help is greatly appreciated. Thanks!
>
> David

What aspect of

SELECT owner, object_name, created, last_ddl_time FROM dba_objects
WHERE created <> last_ddl_time
AND owner NOT IN ('SYS', 'SYSTEM', 'WMSYS');

won't work for you?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)