Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ORA-00922: missing or invalid option

Tags:

oracle

toad

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

like image 260
Thush Avatar asked Aug 21 '14 04:08

Thush


1 Answers

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

like image 157
Pramod Karandikar Avatar answered Nov 11 '22 21:11

Pramod Karandikar