Automation, generating an error in the variable activity.
After installing the upgrade: Toad Data Point 4.0.0.624, it generates an error setting a variable in a script that has been running just fine previously.
The error message: mismatched input '00' expecting ')' line nnn
It is occurring on a variable that references a previously defined variable.
For example, the first variable - p_start_dt - gets set as:
Round( add_days( last_day( add_months( current_date(), -2 ) ), 1 ) )
The next variable generates the error, and is defined as:
Last_day(#p_start_dt#)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center