A couple of us are using TOAD v10 while the rest of the company is using TOAD v9. I am trying to insert a row into a table and some of the string literals have an underscore (like “Mark_Adon”). I can use the SET DEFINE OFF in conjunction with my insert and everything works fine in v9 when I SelectAll and hit F9 but does not work on my v10. The message I get is “ORA-00922: missing or invalid option”.
I did some searching on my own and found a suggestion to right-clich the editor window then check or uncheck the Prompt for Substitution Variables option but it fails wither way.