Are you sure it isn’t compiling the object? It seems to be doing that in my tests here. It’s just not sending notification to the Script Output tab to let you know it was created.
When you copied the view into the editor, did it also include the DROP statement and other ancillary statements besides the “CREATE OR REPLACE” statement? Are you removing those before pressing F9? For example, in a test view locally, Toad copied the following script to the editor when I described a view:
/* Formatted on 7/19/2016 10:58:18 AM (QP5 v5.295) */
TABLE TKD_SCHOOL.SCHOOLVIEW IS
SYNONYM SCHOOLVIEW FOR TKD_SCHOOL.SCHOOLVIEW;
In this case, I would need to move the cursor to within the CREATE OR REPLACE statement in order to use F9. When I do that and follow through the code, it is prompting the user to check out the object, and does appear to execute the CREATE or REPLACE statement successfully.
Can you provide an example of one that doesn’t appear to be working correctly?
From: phyllis.helton_1150 [mailto:firstname.lastname@example.org]
Sent: Tuesday, July 19, 2016 10:44 AM
Subject: [Toad for Oracle - Beta Discussion Forum] Team Coding - Compile Doesn’t
Team Coding - Compile Doesn’t
Thread created by phyllis.helton_1150
I discovered this morning that if I pull a script into my Editor that has not been checked out from Team Coding, if I try to compile it I get the check-out dialog from Team Coding, which I expect. What I didn’t expect is that after the object is checked out, I have to again press F9 to compile because the compile did not actually happen. This is specifically happening on View. This does not appear to be happening with Packages because they check out when I open the files from the TC Manager. (Views don’t appear to automatically check out when I open them using the F4 - Script - Send Script to Editor option - maybe this is part of the problem/solution)
I would expect that if I ask Toad to compile, even if it has to do something else first, that the compile would happen when it can.
Digital Products & Strategies, Cru | Data Sciences & Analytics
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
this post as spam/abuse.