ORA-00922: missing or invalid option

oracle toad
Thush picture Thush · Aug 21, 2014 · Viewed 16.6k times · Source

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

Answer

Pramod Karandikar picture Pramod Karandikar · Aug 21, 2014

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

Related questions

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on having this error? I …

Read More
How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, DATE_UPD, CREATOR, CENTER, ETAT, REQUEST) VALUES('555-vgd9-pllkd-5513', '172.12.23.130', 'N', SYSDATE, SYSDATE, '1554', …

Read More
SQL query for extracting year from a date

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YEAR function can be …

Read More