Retour
-
Titre
Error 'Set_Variable_1 - Error while getting SQL results' when using the Set_Variable activity in Automation -
Description
The error 'Set_Variable_1 - Error while getting SQL results' appears, when running a query such as the one below in an Automation .TAS file in Toad Data Point.
USE TEST
SELECT DISTINCT test.TABLE_NAME
FROM test1.TMP_TABLE_NAME
When you run the same query in the editor, it runs normally, but via automation, this error is seen. It happens on MySQL or Local Storage databases.
Connexion requise
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.