uhesse.com
Retrieve old versions of procedures with Flashback Query
Each stored procedure (or trigger, package etc.) is reflected in DBA_SOURCE, of course. Now imagine, you modified or even dropped a procedure without having the code available to recreate it proper…