How to find out from which table the macro takes data?

Question

Oracle

There is a macro which is written in C++, it also imports data from other macros. When it is executed, it takes data from the Oracle database and generates a report in Excel format. How it is possible to learn from what table it takes the certain data?

Answer 1

The simplest option is to execute "macro written in C++" and then execute the query

select sql_text, sql_fulltext from v$sql where MODULE = 'имя макроса который написан на C++'