ORA-00922: missing or invalid option

Question

IN Toad 9,while executing 'SET DEFINE OFF;' I am getting error as 'ORA-00922: missing or invalid option'

Answer 1

Alternatively, you can do this:

Navigate to View > TOAD Options > And go to "execute/compile" node/item and uncheck the Prompt for substitution variables option.

Or, for editor level change, Right click in the editor and uncheck Prompt for substitution variables