Surely if you have an ampersand, or two, it prompts for a value with F5 or F9? Is this happening? If it is, and no substitution takes place then perhaps it’s a “feature”.
If I remember tomorrow, I’ll try it at work.
On 11 April 2017 15:20:20 BST, droeschley_109 firstname.lastname@example.org wrote:
RE: Editor - substitution variable followed by period (.) not working with F9
Reply by droeschley_109
The problem is the Editor is not doing the substitution when I execute a statement (F9) with a substitution variable followed by a period. It prompts for the value for the substitution variable but doesn’t do the substitution.
SELECT ‘&&sub.suffix’ FROM dual; should display “testsuffix” when I enter “test” as the value - it displays “&&sub.suffix”
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
Sent from my Android device with K-9 Mail. Please excuse my brevity.