ORA-00922: missing or invalid parameter

Question

IN Toad 9 when executing 'SET DEFINE OFF;' I get the error "ORA-00922: missing or invalid option"

+3

Thush 21 Aug At 4:12 am

1 answer

Pramod Karandikar · Answer 1 · 2014-08-21T04:23:14+0000

Alternatively, you can do this:

Go to View

>> TOAD Options

and go to "execute/compile" node/item

and uncheck the box Prompt for substitution variables

.

Or, to change the editor level, right-click in the editor and uncheck Prompt for substitution variables