If you need to restore your changed or dropped package then use this select to retrieve the lost information:http://www.blogger.com/img/blank.gif
select text
from dba_source
as of timestamp systimestamp - interval '10' minute
where name='MY_PACKAGE'
order by line;
For more information read this blog post of Uwe Hesse:
Retrieve old versions of procedures with Flashback Query
Btw: Have you seen the great blog post from Matt how you can use your own interactive images in APEX: APEX Plugin – Body Chart
select text
from dba_source
as of timestamp systimestamp - interval '10' minute
where name='MY_PACKAGE'
order by line;
For more information read this blog post of Uwe Hesse:
Retrieve old versions of procedures with Flashback Query
Btw: Have you seen the great blog post from Matt how you can use your own interactive images in APEX: APEX Plugin – Body Chart
