| Navigator problem for stored procedure [message #385168] |
Fri, 06 February 2009 16:02  |
JannaMontana
Messages: 1
Registered: August 2007
Location: IOWA, USA
|
Junior Member |
|
|
I have been creating a new stored procedure and have been saving and compiling as I go along. When it doesn't compile I comment out the lastest code and work on it in smaller chunks.
But now the problem...I save my code into one .sql file but it opens as two tabs in Toad. I can click on the first tab and see information in the navigator window and it compiles ok. Normally the same will occur with the second tab--information about my code (variables and procedure names, etc). After this last go around, my navigator window for the second tab is missing information. All that displays is "comment". Everything else is gone.
Where did it go and how do I get it back again? Plus it no longer gives me information about any compile errors. I use the "Execute Statement" icon to compile.
Does any one know what's up?
|
|
|
|
| Re: Navigator problem for stored procedure [message #385214 is a reply to message #385168] |
Sat, 07 February 2009 12:43  |
 |
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
| Quote: | I save my code into one .sql file but it opens as two tabs in Toad.
|
That's ridiculous! Why would 1 SQL file occupy 2 tabs?!?
As far as I can tell, if you double-click on a package in TOAD's Schema Browser window, it will open two tabs: one for a package specification, and another one for a package body. A simple SQL is always opened in a single tab. Which means - I'm confused.
Could you, perhaps, post a screenshot? I'd like to see how it looks like (I'm not saying that I'll know what to do, though).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
