RE: Can't execute in TOAD 11.5 editor

The text tab styles provide simple text editing. The ability to do anything with the database from one of these tabs has been removed. This tab style is more efficient when working with text only, but if you need the ability to execute you need to use a SQL or PL/SQL tab. When working with .txt files, you have one of two options. You can change the "File format" setting from the open dialog from Auto to SQL or PL/SQL. This will affect loads from the Open dialog, but if reloading the file using the dropdown on the open dialog to choose from the most recently used list it will not remember your previous file format selection. The second option is to map .txt files to the SQL or PL/SQL tab style. If you often use this extension for SQL this is your best bet. To do so, rt-click in Editor and choose "Configure Editor tab styles..." and modify the Extensions value for the Text style to not include .txt extension and modify SQL or PL/SQL to include the .txt extension.

Michael

From: [email protected] [mailto:[email protected]] On Behalf Of Mark Swarts
Sent: Friday, May 18, 2012 10: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]>
To: "[email protected]" <[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]] On Behalf Of Mark Swarts
Sent: Friday, May 18, 2012 7:55 AM
To: [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.