Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 ******************************************Received on Wed Dec 18 2002 - 03:17:27 CST