tOracle Output show querry

[Anonymous]

Is there a way to print the querry used in tOracle Output component?

[Anonymous · Accepted solution]

Hello,

Here is a global variable tOracleoutput.Query which is the query statement processed. This is an After variable and it returns a string

Note: You have to check the advanced setting "Enable debug mode" for that globalMap variable to be populated.

Best regards

Sabrina

[Anonymous]

Hello,

You can print out the query on to the console by using System.out.println(((String)globalMap.get("tOracleOutput_1_QUERY"))); in the tJava component.

Let us know if it is OK with you.

Best regards

Sabrina

[Anonymous]

After I enabled debug mode in the component it works

[Anonymous]

Hello,

Great it works. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina