Pedro Abreu
Rank: #5630
13Views
1Comments
Advanced SQL log
Question
SQL

Hello,


Is there a way to log the SQL statement being sent to the database when we execute an advanced SQL ?

Let's imagine we have a stored procedure being executed inside an advanced SQL, and we want to be able to see which parameters were sent to that stored procedure.

We can in fact log the parameters by using the "LogMessage" action, but is there a way to log the SQL statement being sent to the database ?


Thanks everyone,

Pedro Abreu

0
0
on 2020-11-24
Copy link to comment
Raphael Ranieri
Rank: #171

Hi Pedro,

I believe that the queries executed stays in the SQL transaction logs in someway, if configured right.

Check this topic in stack overflow.

What you can do to localize the origin of the queries itself is enabling this functionality in OutSystems.

This way your DBA can have more info to work with you to know the exact point the query was triggered.

Cheers and Regards,

RR :) 

0
0
on 2020-11-24
Copy link to comment