I'm setting up a query that references variables defined within an automation script. However trying to use the #Var_Name# syntax as a variable for the query is not working in the automation. I receive the following error:
Value with type Quest.Toad.Workflow.Activities.Database.BindObject not supported
Here's an example:
Variable - BLD_NAM
SELECT PLAYER_ID, MVP_PLAYERID, CLIENT_ID
FROM PlayerID@REMOTE#BLD_NAM# PLAYID
WHERE (IDType = 'P')
If I were to use the '&' for a prompt in the Toad editor, it works, but still does not work in the automation process
Use the Find and Replace activity so it finds all occurrences of #VAR_NAME# and replace with contents of automation variable.
Waiting for fix in a future release of Toad for Data Analysts.