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'

Solution

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

Comments

[Michael S.]

SET DEFINE OFF works for scripts. If you are executing a single statement using F9 you need to follow Pam's advice. It's solid.