AnsweredAssumed Answered

show passed values to a SQL query - Oracle Database

Question asked by cosgh01 Employee on Nov 22, 2018
Latest reply on Nov 22, 2018 by cosgh01

Hello guys,

I have a Java Agent 10.7 SP2 with SQL Bundle installed. I have enabled the following parameters in the SQL bundle:

introscope.agent.sqlagent.sql.rawsql=true

introscope.agent.sqlagent.showparams=true

introscope.agent.sqlagent.resolveBindParams=true

 

I restarted the agent, but the Agent is not able to show all vallues in the Query statement.

Ex: SELECT ADRID CODE, ADRVILLE _ _ ? _ _ ADRVOIE _ _ ? _ _ ADRDISTRICT _ _ ? _ _ ADRCODEPOST LIBELLE FROM ADRESSE WHERE ADRID IN (SELECT ADRID FROM ACTADRESSE WHERE ACTID = ? AND AADTYPE = ?)

 

I stil have the the "?" in the transaction.

How can I solve this issue? Do I need to install a additional bundle like SQL Param Agent?

Thank you.

Outcomes