RE: Can't execute in TOAD 11.5 editor

Ah, I didn’t think about that possibility.  Thanks for the follow up.

From: [email protected] [mailto:[email protected]] On Behalf Of Mark Swarts
Sent: Friday, May 18, 2012 9:12 AM
To: [email protected]
Subject: Re: [toad] Can't execute in TOAD 11.5 editor


I got it. It wasn't the read-only check box. It's the file extension. My file extensions are ".txt". If I use ".sql" or some other file extension, then I can "execute".

Thanks for your help.

________________________________
From: John Dorlon <[email protected]<mailto:[email protected]>>
To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>
Sent: Friday, May 18, 2012 9:03 AM
Subject: RE: [toad] Can't execute in TOAD 11.5 editor


Is the connection read only?  Look on the login screen.  There is a checkbox for that in the grid with all the login entries.  Maybe you accidentally checked it.

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Mark Swarts
Sent: Friday, May 18, 2012 7:55 AM
To: [email protected]<mailto:[email protected]>
Subject: Re: [toad] Can't execute in TOAD 11.5 editor


John,

I'm connected before I open the file. As I said to Bert, I still have TOAD 11.0 on my pc and when I use that version, I don't have any problem.

Thanks for your help,
Mark

________________________________
From: John Dorlon <[email protected]<mailto:[email protected]>>
To: "<[email protected]<mailto:[email protected]>>" <[email protected]<mailto:[email protected]>>
Cc: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>
Sent: Friday, May 18, 2012 8:25 AM
Subject: Re: [toad] Can't execute in TOAD 11.5 editor


Sounds like the editor was opened before a connection was made, and it isn't associated with any connection.   Use the 'change connection' but to do that

- John

On May 18, 2012, at 7:15 AM, "Bert Scalzo" <[email protected]<mailto:[email protected]>> wrote:

Some dumb questions. Is the file attributes marked as read only? Is the database object referenced not granted proper privs? I’m just looking for other external things that could trigger such behavior…..

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Mark Swarts
Sent: Friday, May 18, 2012 7:13 AM
To: [email protected]<mailto:[email protected]>
Subject: [toad] Can't execute in TOAD 11.5 editor


In Toad 11.5, the Execute/compile toolbar button is grayed out and the hot key (F9) does not work when I'm in the editor. I have tried all the available "desktop" options (PL/SQL, SQL). I did not have any problem with this in 11.0.