CODEWITHSUNDEEP
oracle-databasetoad
Thush
Thush

Reputation: 1125

ORA-00922: missing or invalid option

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

Upvotes: 6

Views: 22251

Answers (1)

Pramod Karandikar
Pramod Karandikar

Reputation: 5329

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

Upvotes: 3

Related Questions