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