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'

Thoreau

The SET DEFINE [ON|OFF] command is specific to SQLPlus; it's processed by the SQLPlus client, it's not sent to the database. That statement is not a valid Oracle SQL statement. Some SQLPlus commands are accepted and honored by TOAD if you run the statements as a script; I've used SQLPlus style commands for column formatting, but I've not tested the SET DEFINE command though. – Manheim

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

Dignadignified

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. – Thrive