Home -> Mailing Lists -> Oracle-L -> Need details of Tables being deleted from PL/SQL Package

Need details of Tables being deleted from PL/SQL Package

From: Asad <asad.hasan2004_at_gmail.com>
Date: Tue, 1 Nov 2022 06:13:29 +0530
Message-ID: <CAG3LsKG=vCbgiVh0MshW_L3dFoSBjK=ed4ooVLxTnqevyFoHBg_at_mail.gmail.com> 








Hi All ,



I have a task to identify the  tables from which data is being purged while
executing a apps package .



I checked the package code it seems its doing the following :



execute immediate 'delete from '|| l_detail_rec.table_name||' where '||
l_detail_rec.fk_column ||' in ('||l_con_condition_clause||')';



How to get the list of tables being deleted ?



-- 
Asad Hasan
+91 9582111698

--
http://www.freelists.org/webpage/oracle-l


Received on Tue Nov 01 2022 - 01:43:29 CET












Original text of this message