Re: Querying stored procedures

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 20 May 2004 19:07:53 GMT
Message-ID: <dm7rc.39363$6f5.4136520@attbi_s54>

"David Gibson" <davidg_70_at_hotmail.com> wrote in message news:pan.2004.05.20.17.35.19.428714_at_hotmail.com...
> 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

You can do it all within the database using dbms_job. Then if the OS changes you are golden.
Jim Received on Thu May 20 2004 - 14:07:53 CDT