返回
-
标题
Error 'Set_Variable_1 - Error while getting SQL results' when using the Set_Variable activity in Automation -
说明
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.