Toad World® Forums

Missing or Invalid Option

Hi, when I run the below in Toad I get the message "Missing or Invalid Option" (please see attached). When I run this same code in sqlplus the code executes correctly. I believe this is a bug.

BEGIN
dbms_stats.unlock_schema_stats('EDRMBASELINE');
end;
/

That works ok for me. I have a few thoughts;

Do you have a login.sql or glogin.sql set? (check options -> Scripts)

If I add SET FORMAT ANSICONSOLE to the beginning of the script, I see the same message.

yes. I have the glogin.sql set. I also have "SET FORMAT ANSICONSOLE" in glogin.sql.

I disabled scripts login. Thank you