I’m using a bind variable in my query to prompt users to enter a date. This works fine in the query, but when I try to automate this in a script it doesn’t prompt anymore. In my query I’m using Where A.YEAR_MONTH = :YYYYMM_Data and I’ve created a variable in the script which is YYYYMM_Data , but there is no prompt.
Is there a way to make the prompt work in a script? I’m not looking to schedule the script I just want the users (who are not SQL users) to have the ability to just hit Run and have the SQL run for them - but they need the date prompt.