I’ve just upgraded to Toad for Data Analysts 2.5 and I’m having trouble getting the new automation variables feature to work.
I’ve set the “Row count variable” in my Select to File activity to “rc” (no quotes). The query does select 2761 rows from an Oracle database. Log message indicates “Row count variable rc set to 2761 rows”. However, in the Send Email activity, this variable doesn’t show up in the subject “#rc# Rows Output” or body “You have selected #rc# rows.” The email is sent and received fine, and the attached Excel file looks great. Subject and body both still contain the literal value “#rc#”.