Bert, Thank you for your insight. I've just tracked down the issue. Our administrators recently switched us from using tnsnames.ora to an ldap configuration ....
Just to be clear, I'm under the impression that I'm always connecting to a specific rac instance and therefore am not hitting the issue you describe. But I'll...
Rumpi, I think you just may have found the problem. The "file not found" error you're getting is from the debugger looking for the TNS Names file to make the...
Greg, Thanks for confirming the issue. I'll work with my administrators here either to upgrade or revert to the tnsnames.ora configuration. ... -- Rumpi...
Thanks, unfortunately we are not on maintenance. We were told that our company is going to use PL/SQL Developer because it's so much cheaper than TOAD...
just one thought - going on maintenance is not that expensive - and cheaper than retraining everyone on a new tool - even if that new tool is free :) ...
Bert...I think he is talking about pl/sql developer from Allround Automations as opposed to sql Developer from Oracle. Scott, I would have someone talk to...
how do I show Views in "Table Name Autocomplete"? I have table emp, and view and emp_view. In the edit I type e then <ctrl>. I only get emp not the view. how ...
yes - you are correct - so moving to a new tool for about the same cost a s maintenance - plus having to retrain - yuck :) yes - debugger will be part of base...
like the old Prego sauce commercials - it's in there :) anytime users have questions - the first and best place to start is with toad options use the search...
Oh you will be so happy when 9.6 comes out as the auto-complete (code insight) has been reworked and it now rocks in the Beta. Till then on the views tab...
Thanks Bert, I forgot about that! Of course this is all new and improved for 9.6 :) From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert...
Not only can you see more objects, such as Views, PL/SQL, Object types, synonyms, sequences, and java source, but you can also drill down into other schemas! ...
This will load view names into memory so they can be highlighted and/or used for code insight. You'll suffer a slight performance hit, that's why it's an...
Greg, I've spoken with the DBA here and he's upgraded my version of Toad to 9.5. The debugger now seems to work. Unfortunately I've run into a new problem ...
Yes, I'll be watching the Quest response to this one with interest. I've never seen TOAD handle WITH clauses, either in PL/SQL or in the SQL Editor. I was...
Hi Jeff--I tried your query which I had to modify a bit to get running: with total_dept_sal as ( select sum(sal) total_sal, deptno from emp group by deptno ) ...
I'm pretty sure that this is a parser problem that has been addressed in 9.6. If you are a beta user (or would consider becoming one) then try it in 9.6. ...
Jeff--very strange. I'm also using 9.5.0.31, but with client 8.1. I had hoped it was solved with the major version jump to 9.5, and it was one of the first...
Is there size limit while using SQL*Loader via TOAD. I get an error "maximum size exceeded" when loading data greater then 240 characters. The data is 269...
I believe the "with" syntax arrived in the first release of 9i. At least, the 9.0.1 documentation says, when listing new features, identified the "with"...
Actually, it has been known that TOAD has not supported WITH for some time as Michael says. I just assumed it was still the case, but now I think that it is a...
Actually, I have a slight typo in there -- an extra semicolon after the with select statement. I've now confirmed that this works in SQLPLUS and does not work...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
