Home » SQL & PL/SQL » SQL & PL/SQL » Procedure back
Procedure back [message #441496] Mon, 01 February 2010 08:36 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi Experts ,

Can we get back the PL/SQL stored procedure after droping,
If it is possible give me example
Re: Procedure back [message #441498 is a reply to message #441496] Mon, 01 February 2010 08:41 Go to previous messageGo to next message
ThomasG
Messages: 3186
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Not from Oracle.
Re: Procedure back [message #441505 is a reply to message #441496] Mon, 01 February 2010 09:16 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use 11gr2 and editions.

Regards
Michel
Re: Procedure back [message #441550 is a reply to message #441496] Mon, 01 February 2010 20:34 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
ramesh55.sse wrote on Mon, 01 February 2010 08:36
Hi Experts ,

Can we get back the PL/SQL stored procedure after droping,
If it is possible give me example


Shocked

Dont you keep back up of your Code ?
Re: Procedure back [message #441556 is a reply to message #441550] Mon, 01 February 2010 21:50 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
rahulvb wrote on Tue, 02 February 2010 08:04

Shocked
Don`t you keep back up of your Code ?

Are you saying about "version systems"(like VSS,SVN ...etc ) other than Oracle?


@OP
Michel already suggested Just adding link ....
See this.hope this will help you.

of course you can also write your own programme to do like that a trigger to store the timestamp versions with code.Search within this forum for that kind of logic.

Good luck Smile
sriram Smile
Previous Topic: how to get the report with huge data in the tables
Next Topic: Column total
Goto Forum:
  


Current Time: Sat Oct 01 09:14:59 CDT 2016

Total time taken to generate the page: 0.09440 seconds