Toad World® Forums

Reserved Variable Names?

Something odd has started to happen with one of my weekly reports with the variables:

StartDate (SELECT TO_CHAR(SYSDATE-7,‘MMDDYY’) FROM DUAL)

EndDate (SELECT TO_CHAR(SYSDATE-1,‘MMDDYY’) FROM DUAL)

Previously (and in the Variable testing, no less) these would return dates of 7 days ago and 1 day ago respectively. Pretty easy, right?

Starting about one week ago, both variables started returning the same value - the equivalent of “EndDate”.

I’ve double- and triple-checked my automation script to make sure someone didn’t accidentally replace #StartDate# with #EndDate# - everything is as it should be. In fact, the script hasn’t been modified since I built it.

Are StartDate and EndDate reserved words that suddenly caused a problem? Like I said, up until about a week ago everything generated exactly as I expected it to.

I know I can just go in and change the name of the variables - I’m just concerned that it suddenly stopped working without any changes to the script.