Six Stars

tOracle Output show querry

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: tOracle Output show querry

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.

1.png

Best regards

Sabrina

 

 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
4 REPLIES
Moderator

Re: tOracle Output show querry

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.

1.png

Best regards

Sabrina

 

 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Moderator

Re: tOracle Output show querry

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: tOracle Output show querry

After I enabled debug mode in the component it works
Moderator

Re: tOracle Output show querry

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.