Format instead of execute

"John Graves" <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <[email protected]>
Maybe someone can suggest what is going on here. In the editor I have this:

CURSOR c1 IS SELECT dummy FROM dual;

If I highlight SELECT through ; or SELECT through dual and press F9, I
get the expected output.

If I go up two lines and put in a DECLARE, so it looks like this:

DECLARE

CURSOR c1 IS SELECT dummy FROM dual;

and I highlight the same SELECT through ; or SELECT through dual and
press F9, I get en Edit SQL window that reads:

/* Formatted on 5/8/2012 1:02:55 PM (QP5 v5.185.11230.41888) */
SELECT dummy FROM DUAL;

I'm on TOAD 11.0.0.116 as I haven't had a chance to get the latest
loaded up yet. I often highlight and run the SQL in a cursor before
execution to see the result set as a last sanity check before
execution. I've done this many, many times, but lately I get the Edit
SQL window instead of execution and a result set. Any idea why? Have I
changed some setting in the options by accident or something?

John


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.