The following script runs ok without a date range, but when I want to add a date range, toad does not ask for them when running and the result CSV file is blank.
When I run my sql in toad directly it stops and ask to input the 2 prompts, but does not when calling toad from command line. How can I do this?
SELECT * FROM IND_MAINTENANCES
where pre_maint_created_date between :fromdate and :todate