Compiled code lost
- Thread starter Salz@SQL
- Start date
That's unfortunate. I don't know how much help it will be, but here are a few ideas.
If it has been compiled, open it from the schema browser, copy the code from there and paste it back into your file.
You can check the directory specified in your backup file preference and see if it was put there. It only backs up the last save, so maybe it's there and maybe it's not.
You can look in the directory that you normally save your packages to and sort by the date. Perhaps it was saved by a different name or something?
I hope you can find it!
Mike
If it has been compiled, open it from the schema browser, copy the code from there and paste it back into your file.
You can check the directory specified in your backup file preference and see if it was put there. It only backs up the last save, so maybe it's there and maybe it's not.
You can look in the directory that you normally save your packages to and sort by the date. Perhaps it was saved by a different name or something?
I hope you can find it!
Mike
Hi Mike
Thanks for your concern. But I have an issue more serious than you were thinking.
Actually the function is totally lost.I was not saving the changes in some file Since I just compiled the whole pakage(along with the new function). But due to some error(i dont know whether it was on oracle side or pl/sql developer's ) the package now is not showing the function added by me. The package in database is now without that function and even in all_source it's missing !!
Thanks for your concern. But I have an issue more serious than you were thinking.
Actually the function is totally lost.I was not saving the changes in some file Since I just compiled the whole pakage(along with the new function). But due to some error(i dont know whether it was on oracle side or pl/sql developer's ) the package now is not showing the function added by me. The package in database is now without that function and even in all_source it's missing !!
Stew Stryker
Member³
Salz,
I'm sympathetic, really I am.
But how long have you been working with computers that you didn't bother saving your work as you went?
Not that it'll help now, but I have a strategy that might help in the future (beside the save to disk as you go method). I use the Windows clipboard manager ClipMate, which holds all my clippings so I can wander back through them. Often just before I compile or perform major surgery on my code, I'll just copy the whole thing to the clipboard. So if things go belly-up for whatever reason, I can always get back to where I was. My whole team uses ClipMate for much more than just this, and I'd be much less productive w/o it.
Best of luck,
I'm sympathetic, really I am.
But how long have you been working with computers that you didn't bother saving your work as you went?
Not that it'll help now, but I have a strategy that might help in the future (beside the save to disk as you go method). I use the Windows clipboard manager ClipMate, which holds all my clippings so I can wander back through them. Often just before I compile or perform major surgery on my code, I'll just copy the whole thing to the clipboard. So if things go belly-up for whatever reason, I can always get back to where I was. My whole team uses ClipMate for much more than just this, and I'd be much less productive w/o it.
Best of luck,
Similar threads
- Discussion
