Re: Coding of Stored Procedure

"Charles" <charles_at_sf-express.com> wrote in message news:ed69de45.0212180113.436f9ad9_at_posting.google.com...
> Hi all,
> May anyone help? How can I find out the previous version of some
> stored procedure?

If you mean the code behind the sp that is in the database now then

select text from user_source
where name='<store proc name>'
order by line;

should do it.

If you mean the code that was there before you ran

create or replace procedure blah .......

then you need to go to your version control software if you have it, or restore a backup (either physical or logical).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************