Re: Need details of Tables being deleted from PL/SQL Package

Hi,

Follow the logic of the package to see what values end up in those variables. Ideally you would be logging the final statement somewhere with your existing instrumentation.

I would do this sort of logging at the same point that I’m doing checks that the input values are not sneaky SQL injection (And if you’re not doing that then you need to).

Of course, you can just check what’s in v$sql with a program_id of your package’s object_id and a program_line# of the execute immediate statement. This relies on all the relevant cursors still being in memory. If you do this, don’t forget about SQL injection.

Thanks,
Andy

On Mon, Oct 31, 2022 at 5:43 PM, Asad <asad.hasan2004_at_gmail.com> wrote:

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