Hello! I am attempting to use a variable in a query in the Toad automation designer (v12.11). In control, I use the Create Variable step and I put VAR_CP for variable and TEST for value. Scope is Local (current run). The next step is a script step. Eventually, this will be an update such as: U…

Edit: Oops, you weren't asking about Export Dataset. I'm going to leave this answer just incase it helps anyone else. If your "variable" value just comes from the database, the best way to accomplish that is using a subquery, as I showed above... But, to answer your question about variables...…

Using Variables in a Toad Automation Query

Toad for Oracle & DevOps Toolkit

JohnDorlon August 30, 2024, 5:23pm 21

Sorry, the only way to do it is through a file.

Topic		Replies	Views
Automation Designer variables for data export Toad for Oracle & DevOps Toolkit	14	2568	February 17, 2014
Automation Designer with Variables Toad for Oracle & DevOps Toolkit	2	1187	June 29, 2020
Variables in Toad for Oracle Toad for Oracle & DevOps Toolkit	17	15334	January 12, 2023
Using variables Toad for Oracle & DevOps Toolkit	6	8494	January 31, 2012
Automation - script to update user variable Toad for Oracle & DevOps Toolkit	4	2319	January 17, 2018

Using Variables in a Toad Automation Query

Related topics