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>
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