Home » SQL & PL/SQL » SQL & PL/SQL » Get a Procedure Code (9i)
Get a Procedure Code [message #402692] Tue, 12 May 2009 01:49 Go to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Hi All,
I am using Oracle SQL Developer.....By mistake i overwrite a package....How will i get my old/Previous Code......Please help me...Its urgent.....Any suggestion wil be appreciable
Re: Get a Procedure Code [message #402694 is a reply to message #402692] Tue, 12 May 2009 01:53 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Is it seeded package? Are you using Oracle Applications?
(Or) It is a custom package?

By
Vamsi
Re: Get a Procedure Code [message #402696 is a reply to message #402694] Tue, 12 May 2009 01:59 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Friend i didn't understand the seeded or custom package..........i just creted this package in notepad and run in the ORACLE SQL*PLUS using address(eg. D\Package\a.sql)it is automatically load in Oracle SQL Developer.
Re: Get a Procedure Code [message #402698 is a reply to message #402696] Tue, 12 May 2009 02:08 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Then, I'm not sure.

You could have done this before.

By
Vamsi
Re: Get a Procedure Code [message #402712 is a reply to message #402692] Tue, 12 May 2009 02:49 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You will find the code in your source versioning software.
Oracle is NOT such a software, it does not keep the old versions.

Regards
Michel
Previous Topic: Non key-preserved table, insertion through view
Next Topic: procedure output parameter with precision
Goto Forum:
  


Current Time: Fri Dec 09 04:16:28 CST 2016

Total time taken to generate the page: 0.08641 seconds