OraFAQ Forum: SQL & PL/SQL » Procedure back

Home » SQL & PL/SQL » SQL & PL/SQL » Procedure back

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Procedure back [message #441496]

Mon, 01 February 2010 08:36

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

Report message to a moderator

Re: Procedure back [message #441498 is a reply to message #441496]

Mon, 01 February 2010 08:41

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Not from Oracle.

Report message to a moderator

Re: Procedure back [message #441505 is a reply to message #441496]

Mon, 01 February 2010 09:16

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use 11gr2 and editions.

Regards
Michel

Report message to a moderator

Re: Procedure back [message #441550 is a reply to message #441496]

Mon, 01 February 2010 20:34

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

Dont you keep back up of your Code ?

Report message to a moderator

Re: Procedure back [message #441556 is a reply to message #441550]

Mon, 01 February 2010 21:50

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

rahulvb wrote on Tue, 02 February 2010 08:04

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

Report message to a moderator

Previous Topic:	how to get the report with huge data in the tables
Next Topic:	Column total

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 19:30:45 CST 2024