I’m getting an error message when trying to build an Export Template because Toad comes back with this:
Toad has detected some symbols within the SQL indicating you might be using bind variables. Please define the following variable(s):
" OF MTHS ON SVC"
" OF NSF PYMTS"
These aren’t bind variables - they’re column names, aka AS “# OF MTHS ON SVC” and AS “# OF NSF PYMTS”
Seeing as Oracle doesn’t treat a # symbol within a “” as a bind variable prompt, why is Toad trying to? This is problematic.
If it’s quoted out, it should be ignored.