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.