Danny Torres
Follow / 14 Sep 2016 at 5:03pm / Toad for Oracle
Latest post by on 28 Nov 2017 at 6:27pm

How to get the most out of this forum – Best practices for what information...

Expand content
The better a problem is described, the better the assistance tends to be. In order to better assist with your issue at hand, please include the following information in your initial post. - Product,...

The better a problem is described, the better the assistance tends to be.
In order to better assist with your issue at hand, please include the following information in your initial post.

-          Product, Version, and relevant environment details.

-          Include a screenshot of the problem

-          Describe the problem fully. What result was expected?

-          Can the issue be created on demand or is it intermittent?

-          If the problem can be generated faithfully, what are the exact steps to recreate the problem?

-          Any other pertinent information (see below)


How to create Support Bundles

The support bundle window provides information about several aspects of your Oracle and Toad setups. In addition, the Support Bundle lets you easily report problems to our peer-to-peer mailing lists or directly to Support.
If Toad itself fails, the Error dialog box displays. This type of an error creates a log, saved as toad.elf. This Eureka LogFile (.elf) contains both the application information and the callstack of the error created, and can be very helpful to Support in solving issues you are having with Toad.

To create a support bundle:

Select Help | Support Bundle.

Review the following for additional information:

Email Quest Support

This opens the "Email Quest Support" window with instructions and links to contact Support, and to open a new case or service request.

Quest Web Support

This opens Quest Software's award-winning Support portal in your default browser, with access to Licensing Assistance, the searchable Knowledge Base, product downloads and more.

Attach TOAD.INI (or SQL Tuning Support details) to emails

If selected, this attaches the details to any email sent through the support bundle, whether it is to the peer-to-peer Toad list or to Support.

 *Note: Please refrain from including private data in your posts. Be as thorough as you can with the provided info. We will reply to you as quick as possible. We are glad to assist you. 

Release Information: 

Here are some key links: 

  • Link to Documentation:

https://support.quest.com/toad-for-oracle        

(Release Notes includes latest release enhancements; Installation Guide includes pre-requisites; Getting Started includes product features) 

  • Link to Downloads (existing customers):

https://support.quest.com/toad-for-oracle/download-new-releases 

  • Link to Trial (new customers):

https://www.quest.com/products/toad-for-oracle/software-downloads.aspx

  • Knowledge Base Articles:

https://support.quest.com/toad-for-oracle/kb 

The Support Knowledge Base includes Videos, Tutorials, and other information intended to help users.

Feel free to browse the knowledge base articles. Remember to sign in to your account to view.

4895 3 / Create an account to join the discussion.
Jon.Lin
Follow / 8 Sep 2016 at 10:08pm / Toad for Oracle
Latest post by on 26 Jun 2017 at 1:55pm

Latest Release Information

Expand content
Here you can find information on our latest release, from features to downloads & documentation: https://support.quest.com/spotlight-on-oracle

Here you can find information on our latest release, from features to downloads & documentation:

   https://support.quest.com/spotlight-on-oracle

4012 2 / Create an account to join the discussion.
ben_michaud
Follow / 21 May 2018 at 4:10pm / Toad for Oracle
Latest post by on 24 May 2018 at 3:58am

SQL runs but not in optimizer - need error details

Expand content
I have a select statement with bind variables gathered using Oracle tooling while running a package via a Java Web application. I can run the SQL in Toad using the "Execute/Compile statement at caret"...

I have a select statement with bind variables gathered using Oracle tooling while running a package via a Java Web application. I can run the SQL in Toad using the "Execute/Compile statement at caret" command, setting the variables. Here is the SQL:

Options screens:

(NOTE: I turned off "Refactor SQL before optimizing," and that got rid of a very unhelpful "Exception was thrown" error.)

When I try to run the same SQL using the "Auto-optimize SQL at caret using re-writes", I get this error message: "ORA-00905: missing keyword"

Is there any way I could get more detail on where this mysterious error is in the statement? I tried running it in SQL*Plus, but it works there.

Thanks in advance for any help you could offer.

Oracle 11.2.0.4.0

Toad 32-bit 13.0.0.80

Windows 10

42 1 / Create an account to join the discussion.
David U
Follow / 7 May 2018 at 2:36pm / Toad for Oracle
Latest post by on 24 May 2018 at 2:23am

Parentheses matching

Expand content
Will we ever get parenthesis matching the way it was before the v12.?? rewrite of Toad? Before the rewrite, I could click anywhere between 2 parentheses and they would be bolded, allowing me to easily...

Will we ever get parenthesis matching the way it was before the v12.?? rewrite of Toad?  Before the rewrite, I could click anywhere between 2 parentheses and they would be bolded, allowing me to easily see the start and end of the grouping I've clicked into.  Since the rewrite, I first have to find the correct parenthesis and click next to it to have the other end highlighted.

Unanswered 312 2 / Create an account to join the discussion.
droeschley_109
Follow / 23 May 2018 at 4:52pm / Toad for Oracle Beta Program
Latest post by on 23 May 2018 at 7:17pm

Drop column in Edtior, SB data grid with filter displays error

Expand content
in SB, display table data grid with filter, go to Columns tab (or some other tab), from Editor drop column, go back to SB and click on Data tab. Error popup that won't go away. I believe this is the...

in SB, display table data grid with filter, go to Columns tab (or some other tab), from Editor drop column, go back to SB and click on Data tab.  Error popup that won't go away.  I believe this is the sequence of events.  Note that the filter did NOT include the dropped column.  I clicked OK and X many, many times.  Table has over 300,000 rows so I assumed popup would continue and opted to kill Toad and restart.  

toad131.docxtoad131.docx

27 6 / Create an account to join the discussion.