6

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

Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
Thush
  • 975
  • 3
  • 8
  • 11
  • 9
    The `SET DEFINE [ON|OFF]` command is specific to SQL*Plus; it's processed by the SQL*Plus client, it's not sent to the database. That statement is not a valid Oracle SQL statement. Some SQL*Plus commands are accepted and honored by TOAD if you run the statements as a script; I've used SQL*Plus style commands for column formatting, but I've not tested the `SET DEFINE` command though. – spencer7593 Aug 21 '14 at 04:27

1 Answers1

3

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

Pramod Karandikar
  • 5,289
  • 7
  • 43
  • 68
  • 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. – Michael S. Aug 21 '14 at 14:17